gwsv-it Member

If you're not worried about removing duplicates, then UNION ALLshould skip the DISTINCT step of the UNION operation and improve your performance a bit.

Sorry for the slow reply. We've been casting as date before the data gets to Domo wherever possible. Some of our "omnichannel" E-commerce systems store the datetime in the whatever timezone the marketplace uses which made it even more confusing. We would only preserve the time (and make the timezone correction) when it's…

Thanks for the workaround suggestions. Sorry for the super late reply!

Casting as Date prevents the timezone correction for Date fields. The DATE() function (and just regular date columns) in SuiteAnalytics return DateTimes and need to be explicitly cast as dates. I'm still not sure I understand how they're handled in different transforms yet, but at least that is good to go. Thanks to…

Just got off the phone with Domo Support and everything is working now. There are some required fields for each request not necessarily specified in the documentation. For example, to update users you need at least the email, name, and role fields. I was told they'd be updating the docs or modifying the API when they get a…

Actually still having problems now that I have admin credentials. Will try and update the thread if we're able to iron out what's actually going on. 

I thought I'd update that the issue I was having has been resolved. You need to setup the clientId/clientSecret as a user assigned the Administrator role. The error reporting was improved this week and now notes this as the issue. If the API docs haven't been updated as well, that should definitely be noted somewhere on…

I've actually been having issues with all of the requests that use PUT (and maybe POST). I keep getting a JSON object with an HTTP 500 error: { status: 500, statusReason: 'Internal Server Error', message: 'Internal Server Error', toe: '2MRF9S7TIE-POTN6-VO14T' } I've triple checked that I'm sending everything according to…

We run it on Windows Server 2008 without issue.

We pull in Google AdWords data using a short Google Apps script to export the numbers to a Google Sheet daily, then share that sheet with a Google Sheets user on our Domo instance. I was on the clock when I wrote the Google Apps script, otherwise I would just share the source code with you. However, if you're familiar with…