If I wanted to reconstruct the transaction detail report from the underlying objects coming from the REST API, does anyone have a comprehensive list of data showing what I’d have to pull? I assume it’s a mix of JEs + Bills + Invoices for a given period?

Super helpful @battk! Do you know if there’s a non-SuiteAnalytics way to get there?

you want the suiteanalytics way if you are working with the rest api

What if the company doesn’t pay for the SuiteAnalytics module? I assumed that if I pulled every object from the underlying tables I could still reconstruct the report

you probably could, but that involves going though every transaction one by one, and the rest api is not being developed fast enough to support all transactions

that makes sense - we’re building a batch system to try and do that, though! Interesting re: workbooks, so even if we don’t pay for SuiteAnalytics you think we could still run the workbook queries and trigger them via REST?

SuiteAnalytics Workbook is not a paid feature

Interesting. I’m pretty new to the NS API world, was under the impression that SuiteAnalytics and all the SQL access was feature-gated

sounds like you are thinking of SuiteAnalytics Connect

ah! such confusing naming. So SuiteAnalytics workbooks over REST are ok, but Connect via JDBC/ODBC are not