Sunday, June 14, 2020

#778 OIC and Netsuite --> Custom fields revisited

This post again is mainly note for myself - however, others may also find it useful!

Here I detail how to create a new custom field in Netsuite.

This field will hold the ecological rating of the customer - one of the following values -
A, B, or C.

I create what is known in Netsuite as an Entity Field

































I also created a new List Record to hold the valid values of A, B and C.

I apply this field to the Customer object.

Now to the Display settings -














Looks good - let's check out the result -










Great stuff, as we say in Eireann!

Now to accessing this via the Netsuite adapter.

First example is a Customer GET -

Response from query, based on internalID, is as follows - Note the format of EcoRating -


























Second example is a Customer ADD -

Here is my simple integration -









Here is the mapper - I check for my custom field -



















Here it is -

































Here I need to set the listItemId.

From the GET response, we see the Id for A is 1.
B is 2, C is 3.

I put this logic into an OIC lookup -






































I only map  fields - customer name and ecoRating.

Now Activate and Test -

























Validate in Netsuite













Tuesday, June 9, 2020

#776 OIC June 2020 release UI updates

This release sees the introduction of the Oracle JET based OIC UI.
It looks better and has more functionality - what more can I say?

Maybe give you some idea of what is now available -

For those who want more info,
please see my colleague Antony's blog post here

There is also a compelling video from Ankur available here

New Menu Structure

This allows for easier navigation in OIC

Example -

















Note: only the menu has been refreshed.
Net, net, the idea here is for you to be able to do your work in OIC,
with the least amount of navigation/clicking around.

More details in Antony's blog post.

Monitoring

New look and feel -


Monitoring -- Usage Metrics






















Extremely useful, also the facility to export the usage data.























My Favourite New Features


Filtering







































Inline configuration of integrations -




























This makes it very easy to switch your connections e.g. from dev to test to production.

Integration Creation dialogue -





















I really like the additions here - the ability to enter a documentation url - the keywords.

You can, of course, search on keywords -













Grid / Table view of Integrations -


















Easier Access to Actions -








Note the 3 icons above - Edit - Activate - Actions





















Other ergonomic features include the global setting for Recommendations - a global on/off switch
Settings - Integrations - Recommendations -














Activate and Run -





















Sunday, June 7, 2020

#775 - OIC Packages - cool feature I didn't know we had















I also preach about the efficacy of using packages to organise related integrations.
e.g. all of my HCM2Payroll integrations go into the pck_hcm2payroll - you get the idea.

I then proceed to demo the creation of an integration and forget to add it to a package.
I'll have to stop doing this!

Now I can do this afterwards.

Simple example -



 














The above is the integration from the previous post.

I open the integration in edit mode - and click on the menu option - Primary Info -























Here I can add package details - either entering a new package or selecting an existing one.


#774 OIC --> Evernote Adapter

Apparently an elephant never forgets - I do, hence my post -

Again, all text in italics from the Oracle docs.




Starting point, as always, is the Oracle docs here

So what is a typical integration use case involving Evernote?


The Evernote Adapter can be used in a variety of scenarios.
For example, you can collect rich information about your customers, including notes,
contact details, and other information into secure notes that only authorized team
members can view in one place through Evernote. To collect contact information, use
the Oracle Service Cloud (RightNow) Adapter.
Evernote offers a REST api, so there are some pre-reqs to leveraging this via the OIC Evernote adapter.

Pre-requisites

1. Sign in to Evernote - yes, it is free.

2. Navigate to dev.evernote.com











3. Click on the Get API Key button





























Note - this key is valid only for the Evernote sandbox environment.

From Evernote - Your API key has been activated on our Sandbox development server. This is the server you'll connect to during development and testing. Once your project is ready for production use, you'll need to have your key activated on Evernote's production environment.

Activate the API Key -




















Now this will take some time - a couple of days -
but you will eventually get an email from Ms. Evernote herself -













Integrating with Evernote via OIC
















Note: only Invoke functionality is available with this adapter.












Client Id: Consumer Key
Client Secret: Consumer Secret

Click Provide Consent -

You will be transferred to the following Evernote screen -































So many NOTs - but, after all - I did select basic access!




































I now create a simple integration to leverage this connection -




















I now drop the Evernote connection and configure as follows -


















The CreateNote payload is as follows -


























I map as follows -












I also map the response. Evernote returns the GUID of the note created.

Activate and test -
















Validate in Evernote -