WHM Contributor

Support solved the biggest issue. They sent a copy of the JSON returned by the API and I realized that eventtime is referenced as time in the response. Now I have the event time and can load overlapping data and remove duplicates.

Thanks, found the answer after I had posted... problem solved (except it does not work in mobile - bugged)

I found that if you exclude the dataset specification, it applies the filter to all datasets on the page... 

Whiskey Tango Foxtrot?!?! I have been looking for this question for half an hour and only found the link to the thread after posting, in essence, the exact same question. Thanks for doing all this work ahead of me! I will have to test out your solutions

Thanks Dani! I do not know of anyone not annoyed by that popup! yes, feature request it is! The other thing is that it is not even a "share with someone else" it is an "invite someone to Domo", not that "share" would be any less annoying ? Thanks tons for reaching out! W

Thanks! And I got a 2 year Dojo anniversary badge! Any word on turning off the popup? Thanks again for fixing my Dojo account!

Check out this post : https://dojo.domo.com/t5/New-to-Domo/Is-anyone-using-the-DomoApi/m-p/9121/highlight/false#M226 the code is for extracting a simply 4 column dataset but it works. 

It turns out that the "RowCount" column in the Domo data set was actually " RowCount" (with the leading space). Many thanks to Matt for pointing that out, I doubt I would have found that for days. So getting the data out is pretty easy - just make sure your column names match the actual names in the data set ? The Code…

I am working on using C# and the DomoApi to write code for extracting data sets. We need to pull tons of data out for other systems to consume. The SDK is proving a challenge but I am making some progress. We initially were planning to use Boomi and the API but C# is well, free. ?

We need this too and are looking for a solution.

I ran the job from workbench with no issue. Tested the account conneciton in WB through settings... still get the same error. If I can I will try rebooting... you never know... Rebooting made no difference...

Workbench 4 I ended up doing a replace in a transform to replace the year with something in hte future that still looks like a year to Domo - 2099. It would be nice if the definitions of what Workbench considers an error were listsed somewhere. or even better were configurable... Sorry for the delayed response.

I thought I had replied to myself... I had forgotten there were SQL options. I was trying to use the "magic" option. We are dumping entire table structures so I should be able to use tons of SQL already written directly against the database to create my data sets. We are just getting Domo in and trying to figure out the…