KristiKovacs Member

@zcameron - That dataset is a Google BigQuery I tried with another dataset that's a Google Sheet Connector and saw the same error response. This dataset had 30k rows unlike the Google BigQuery which is 257 million rows

@zcameron Thanks for responding, that worked! I'm now connected but I came across another error when running the export-data I see Could not find acceptable representation export-data -i {my_dataset} -f test.csv --------- An error occured while executing the command: Not Acceptable…

@zcameron - I've just downloaded the jar file and I have the cli open, I tried to run: export-data -i {my_dataset_id} -f test.csv and I see Unrecognized command I then tried to run the connect statement thinking perhaps that would work, I am an admin but I see the unauthorized error: connect -s {domain_name} -t {my_token}…

@zcameron - Since my dataset is really big, 257 mill rows, I have it set to query for only 3 days of data at a time (we have data back from 2018!) so the API keeps timing out. :( What is the rate limit for the API?

Ahh @zcameron I found out its actually because I had a really old version of pydomo and just updated to the newest one!. ty!

@zcameron - I keep seeing the following error when I try to use the ds_query method: 'Domo' object has no attribute 'ds_query' I tried with domo = Domo(client_id, client_secret, logger_name='foo', log_level=logging.INFO, api_host=apihost) domo.query(...) but I see the error: AttributeError: 'Domo' object has no attribute…

Oh!! this would work, thank you @zcameron !

Hi @GrantSmith - ignore that last message, I just needed to change it to "datasets" . But the dataset I'm trying to download is 257 million rows, and it seems to be timing out each time I try the code you had sent, is there a way to split it out into chunks perhaps within the code so this doesn't happen?

hi @GrantSmith - when I try this I see the error: 'Domo' object has no attribute 'dataset'

@GrantSmith - Also, regarding the logger part, can you clarify more on what exactly to add for this parameter?

Hi @GrantSmith , thanks for responding. The Transport bit is confusing me. Do I also have to call the DomoAPITransport class in order to call the DataSetClient? dataset = DataSetClient(transport=DomoAPITransport(client_id, client_secret, api_host, use_https, logger, request_timeout), logger =logger) include_csv_header =…

@MarkSnodgrass never mind,I got it! thank you for your help!

Hi @MarkSnodgrass , that looks like it will work, but if I do offset=5000 (because I'm not sure of the exact amount of users) it returns nothing, and then it only gives me the last names starting with the letter V . Can you show me an example of how to use offset and get all the users