Thursday, November 26, 2020

#815 OIC --> Netsuite to Object Storage

 simple use case here - customer wants to extract data from Netsuite and store it in Object Storage -

Step 1 is to create a bucket in object storage. This will be where the data will be stored.

My colleague Daniel T. has a great post describing how to do that here 
A big thanks to my colleague Ravi P. for the Object Storage setup.

Step 2- Create the REST connection to Object Storage Service in OIC.

Tenancy OCID can be found here -

User OCID can be found here - 

Private Key is what you uploaded to Object Storage Service

Fingerprint can be found here - 

Step 3 - Now to the Integration itself - 

I use the Netsuite adapter to get customers whose name include "Dublin" -

I have a lot of such.

I use the Search option in the wizard and configure the mapping as follows -

operator is set to "contains"

I loop over each customer returned and use the STAGE FILE action to write customer data (company name, date created) to a "nn.txt" file in the OIC VFS (Virtual File System)

Note I also assign the file reference to a variable. I can use this later when writing to object storage.

Once all customers have been processed - 

I use the Object Storage REST connection (StoreData) - configured as follows - 


Note the resource uri - 

Check out the full REST api doc for Object Storage Service here

Mapping is simple - I just pass the file reference from the variable - 

Step 4 - Test 

5 Dublin customers processed -

I validate the result in Object Storage -

No comments: