#1167 - OIC Object Storage Native Action - Compartment not listed

Introduction 

Some folks might hit this issue - you want to use the OCI Object Storage Native Action, but you do not see your compartment in the wizard list.

Two things to note here -

1. OIC needs to have access to Object Storage, in order to use the native action. You need to apply a couple of policies to ensure this.

2. The OIC Native Action for Object Storage uses the typical wizard flow that we all know and love. In the wizard, you need to select the target compartment from a list. The UI will list up to 25 compartments, so you may not see your compartment in the list. 

The Policies

Polices for object storage can be applied to a dynamic group. This dynamic group can include your OIC instance(s).

The policy statements I used are -

Allow dynamic-group yourDynGroup to manage buckets in compartment yourObjectStorageCompartment

Allow dynamic-group yourDynGroup to manage objects in compartment yourObjectStorageCompartment

Allow dynamic-group yourDynGroup to read objectstorage-namespaces in compartment yourObjectStorageCompartment

The Dynamic Group

this I define as follows - 

As you can see, I've included 4 OIC instances in the group.

The relevant resource ids ending in _APPID can be found in the Oracle Cloud Services entry for that OIC instance -

Click on the OAuth configuration tab - 

Remember the 25 limit in the list? Don't fret, if your compartment is not included. Just select another one, however, to do this successfully, you will need to ensure the relevant policies have been created to give you access to the compartment you can select.

e.g. your object storage compartment is AAA, and you have executed the policy statements to give OIC access to Object storage buckets etc. in compartment AAA. However, you do not see compartment AAA in the list, when configuring the OCI Object Storage native action in OIC. However, you do see compartment BBB. Then execute the 3 policy statements for compartment BBB as well. You can then select BBB in the wizard and, then, in the mapper, set he target compartment id to that of AAA, thus overwriting what you have configured. More details below -  

Using the Native Action

Note, I've selected the compartment ending in Integration, but this is not the one I want. I select it anyway, as I have access to this compartment.

I then edit the mapper - 

and set the compartment id to that of my target compartment - 

Here are some of the buckets in my compartment.

I now run the scheduled integration and check the activity stream - 

#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 -