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.
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):
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.