Extracting NetSuite Reports

[ravikristipati]

Hi Everyone, 

Is anyone tried extracting reports from NetSuite like income statement, balance sheet or cash flow statements etc.. ? if yes, could you please share the process ?

[Pratik14]

Hi, Did you try this?

Using the NetSuite Connector, Select the action Search standard records. Workato will pull the raw data rows in JSON format. You can then use Workato's data manipulation tools to format it into a CSV or push the raw data directly into your destination app (like Snowflake, Google Sheets, or a BI tool) to be visualized.

[ravikristipati]

Hi @Pratik14 - Thanks for the response. What object should we select to extract data from Report Object in Search standard records. Are you are suggesting pull underline database (like transactions, customer etc.) data tables, source the data into destination app and build reports from scratch in destination app ? If yes, it mightn't be feasible for us as it might need lot of efforts to build reports.