ContributionsMost RecentMost LikesSolutionsSearch specifications I have a table with people's names in it. One (maybe more down the road) person has punctuation in their name (French: L'Name). When I search their name QB returns nothing. When I put any punctuation into the search bar nothing shows up... Is there some trick I can use to work around this? Hoping there's some search functionality that I can use to search names like this. Thanks! ------------------------------ Edwin Reik ------------------------------ Re: add data to Quickbase using python requests libraryAre you still working with Python and Quickbase? I could use help writing API calls using post requests ------------------------------ Edwin Reik ------------------------------ Re: Building URL to download CSVI think that we're getting close but not 100% that this is the right solution. When I use this method: 'https://eagleview.quickbase.com/db/bpw3pr8nu?a=q&qid=31' + '&opts=csv' works when I'm signed in. the csv that comes out is named X. But when I use the final method mentioned above: 'https://eagleview.quickbase.com/db/bpw3pr8nu?a=api_genresultstable&qid=31&usertoken=*secret*' (no mention of options csv) opens a page with the correct table present, but doesn't download the csv. This works when I'm not signed in. when I do the same as above but add '&options=csv' it downloads a CSV, but not the one that is being shown (same wrong one as mentioned above)... the csv comes out named Y. I don'tbelieveit's a matter of adjusting clist but I really have no idea. I think it's actually pointing in the wrong place ------------------------------ Edwin Reik ------------------------------ Re: Building URL to download CSV When I try this and print(r.url) I get the signin page. This is what happened when i tried to write my API request which i believe means I'm not getting in. If you're able to support with building a URL that works I'd be satisfied. 'https://eagleview.quickbase.com/db/bpw3pr8nu?a=q&qid=31' + '&opts=csv' works when I'm signed in. 'https://eagleview.quickbase.com/db/bpw3pr8nu?' + 'a=api_genresultstable&qid=31&options=csv&usertoken=SECRET' works when I'm not signed in, but downloads the wrong table! 'https://eagleview.quickbase.com/db/bpw3pr8nu?a=api_genresultstable&qid=31&usertoken=*secret*' (no mention of options csv) opens a page with the correct table present, but doesn't download the csv. This works when I'm not signed in. when I do the same as above but add '&options=csv' it downloads a CSV, but not the one that is being shown (same wrong one as mentioned above)... What am I missing that can specify what the url is grabbing ------------------------------ Edwin Reik ------------------------------ Re: Building URL to download CSVThanks for the response Blake. The URL calls work fine with my python automation but I'm open to a more robust option. I just need to automate pulling the table and saving it so I can manipulate the data. I've been looking here: https://help.quickbase.com/api-guide/gen_results_table.html#URL_Alternative What would the API call look like? ------------------------------ Edwin Reik ------------------------------ Building URL to download CSV I'm building some automations outside of Quickbase and have found the best way to pull data has been to build a URL using a usertoken that pulls data into a CSV that I process externally with python. For previous tables I've used this basic format: qb URL: https://company.quickbase.com/db/dbID?a=q&qid=34 url = 'https://company.quickbase.com/db/dbID(from original URL)?a=api_genresultstable&qid=34(from original URL)&options=csv&usertoken=private_token' However, when i build a URL call based on the URL below it pulls data from the wrong table... WHY. https://company.quickbase.com/db/dbID?a=q&qid=31 Would love some insight on how to adjust my URL call to have it pull the correct data. p.s. this works as long as I'm already signed in, but I need to do this when I'm not necessarily signed in: https://company.quickbase.com/db/dbID&opts=csv Thanks, Ed ------------------------------ Edwin Reik ------------------------------