Hello. I used the export to SuiteQL ability on a ...
# suiteanalytics
b
Hello. I used the export to SuiteQL ability on a suiteanalytics dataset to run against the rest api. When I try the query in Tim D's suitelet the SuiteQL query runs great, but when I try as a SuiteQL as a rest api call from Workato it returns no records. The status field on the WHERE clause seems to be the culprit because it runs just fine without the following: "TRANSACTION"."TYPE" IN ('PurchOrd') AND "TRANSACTION".status IN ('PurchOrd:D', 'PurchOrd:F', 'PurchOrd:E', 'PurchOrd:B')