netsuite Archives

Why is ‘a1’ added at the end of sql query in json config file meant for data extraction from NetSuite? Not adding that can cause error?

November 29, 2022 by Magenaut

I am working on extracting data from Netsuite into Databricks File Storage. I am doing it by scripting a json and executing it through Azure Data Factory . This JSON has a part where you specify the query to use when extracting from Netsuite. It is called “incrementalSql”. I see quite often that here, an ‘a1’ is added at the end.

NetSuite Saved Search: Showing line items that match a child item but also show line items that don’t have a child?

November 27, 2022 by Magenaut

I am trying to show a specific field on a child record, but I also don’t want to exclude line items that don’t have a child record, I am unsure how to achieve this… This is what I had tried (and wouldn’t work on my Transaction saved search):

Oauth implementation in netsuite using php

October 17, 2022 by Magenaut

I have tried to access Netsuite by account id, username and password using PHP Toolkit. And I can get customer details using the above credentials. i have access token. But Now I tried to access Netsuite using the access token. I need PHP code to access Netsuite using token and I want to get customer details.