question

PrashantMeshram-1128 avatar image
0 Votes"
PrashantMeshram-1128 asked PrashantMeshram-1128 commented

Netsuite to Azure Data Lake or DW using API OAUTH1.0

![![![196811-image.png][1]][1]][1]


azure-data-factoryazure-synapse-analyticsazure-api-management
image.png (12.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered PrashantMeshram-1128 commented

Hi @PrashantMeshram-1128 ,

Thank you for posting query in Microsoft Q&A Platform.

Azure data factory doesn't has in built connector for NetSuit. Hence we should consider making API call to fetch data and load to sink systems. Click here to see list of available connectors in Azure data factory.

We can use REST connector or HTTP connector datasets for source data fetch and load it to sink systems. Please check below links which explain how to copy data by using REST and HTTP connectors.

There is something called custom activity. We can use it to move data to/from a data store that the ADF does not support, or to transform/process data in a way that isn't supported by the ADF, you can create a Custom activity with your own data movement or transformation logic and use the activity in a pipeline. The custom activity runs your customized code logic on an Azure Batch pool of virtual machines. Click here to know more details about custom activity.

Hope this helps. Please let us know how it goes. Thank you.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PrashantMeshram-1128 , Just check if you get chance to see above and share updates? Please feel free to let us know if you found any other workarounds. Thank you.

0 Votes 0 ·

Thank You @ShaikMaheer-MSFT. This I have already gone through. But here I am trying for a token based authentication option to call the API. Is there any specific example that you can show to call an API using the token based authentication. For now I tried to connect to netsuite using the ODBC connector but could not find anything which can help me out with the token based API call.
It would be of great help if you can provide an example for this.

Thank you.

0 Votes 0 ·