-
Quickbooks Chart of Accounts report has dropped Account Name and Account ID
We have a dataset that uses the Quickbooks Online Advanced connector to pull our Chart of Accounts from Quickbooks every 4 hours. It ran as normal at 3am Central this morning. Then at 7am Central the Account and Account ID columns were empty. Anyone else seeing this? I tried duplicating the dataset and re-running and the…
-
Any way to pull in basic Quickbooks records? (Customers, Vendors, etc.)
I can't find a way, using either of the included Quickbooks Online connectors, to pull basic lists of records from Quickbooks -- e.g., my Customer list, my Vendor list, Sales Receipts, etc. All I see are reports, which are nice but don't necessarily include all the data I would need. For example, a G/L report doesn't…
-
generic OAuth redirection URL
Hi, I'm trying to pull data into Domo from another vendor's API using the "JSON Advanced with custom parsing for OAuth" connector (found in your Domo instance at /connectors/com.domo.connector.json.customparsing.oauth). I'm not able to get past the step of configuring the DataSet credentials, because I don't know what…
-
Reusable dataflows / ETLs
We're trying to come up with a good strategy for dealing with large datasets that contain mostly historical data but need to undergo complex transformations in a dataflow or ETL. For example, our user activity log (currently about 7M rows) needs to be joined to several other tables and then we need to segment the activity…
-
Magic ETL trigger timing - input datasets of varied size
I think I just discovered that if a magic ETL is configured to run "only when datasets are updated", and has multiple input datasets, it will start running as soon as the smallest/quicket input dataset has been updated. If a larger/slower input dataset finishes updating before the ETL finishes running, the ETL will not run…
-
DataSet query: unauthorized?
I'm trying to use the 'query' endpoint of the DataSet API but I'm getting an Unauthorized response. Not sure if I'm formulating the query incorrectly or if I need to adjust permissions within Domo. (So far this problem has been specific to querying -- I can programatically list, retrieve, and export datasets just fine. All…
