2282997 - How to create a simple Boomi process to trigger query operation on OData API entity

This KBA explains step by step walk through for Query operation of OData entity in Boomi using SFOdata.PerPerson as an example.

Note:

1. This KBA is made using salesdemo instance, hence while choosing the endpoint URL please use appropriate URL by referring the below KBAs (the same are deep linked at the end of the KBA)

• 2215682 - Successfactors API URLs for different Data Centers
• 2192064 - SF hosted Boomi atom's base URL for different DataCenters

2. Also, HCM Suite Boomi Development Standards Guide is attached to the KBA. Please go through the same before building a project.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Boomi

Let’s start: In the initial step choose no data(we can also start right away the process building by choosing connector also)

1. We will start by designing a connector:

i. Pull a connector step into the Boomi interface design portlet.

ii. Choose SFSF in connector step, action accordingly to the requirement(here I have chosen query)

2. To design a connector and perform an operation, we need a connection. Let’s design it.(Here I have used my company ID and username)

i. Use appropriate URL.

ii. Check the checkbox which says Enable SF oData entity import.

iii. Configure the companyID, username and password.

iv. Configure the HTTP timeout.

3. Next is designing an operation

i. First option is to select the Return Application Error Responses(Best Practices)

ii. Click on import option to import the profile.

4. After clicking the import option a window pops up, this is for importing the metadata for the entity

i. Choose cloud connection.

ii. Choose the connection we designed in step 2.

iii. Filter the entity name by looking in the OData date dictionary.

iv. OData import depth is defined based on the number of levels we want to navigate(xpath).

v. Click Next.

Note: If in this step if you get “Invalid session” error while connector fetches the metadata, please choose Atom instead of cloud and choose one of SFSF cloud atom, choose this atom based on the DC where the company ID is based on. (For EG: sales demo is on DC-4, hence choose a DC-4 cloud SFSF atom)

5. Choose the SFOData.PerPerson from the drop down, after selecting click next

6. Click Finish.

7. Save and close it. In this step, we choose the fields which we want in the select Clause. This is basically needed if we want to limit our query response. Also, we can choose what field should be in the query response by checking/ un- checking the checkbox next to each field.

8. Here we can use filter condition under filters.

9. This is the Logical operator where we can combine more than one Where clause. Either we can use AND or OR operator, based on the requirement, and you can nest the levels inside.

10. Save and close, now we have created an operation. To supply value for the filter, Switch from the General tab to Parameter tab

1. Click on the plus.

ii. Here choose the search parameter to select the filter which was defined in the later step.

         iii. Select the filter .click ok.

       iv. Based on the type set the value to it.(Here for sample purpose we have chosen Static)

11. Click ok add a stop step at the end. Save the interface and run it.

Boomi, Boomi, Depth, Query Operation, Query Operation using boomi. , KBA , LOD-SF-INT-BOM , Standard SF to 3rd Party Boomi Content , LOD-SF-INT-API , API & Adhoc API Framework , How To