8. Auto Create Query based on do mapping

Previously, when you do the mapping no query will be created. However, to make the thing quite easier we enhance our tool (Mapping Editor) to have a better performance. When you mapping on Outbound Interface, it will auto-generate the query in the SOQL Query to select sObject data section on the interface page, after saving. All you do is just drag and drop the field you want to select. To generate IStructure, you have to edit Query Manually on SOQL Query to select sObject data Field. Likewise, it will generate IStructure automatically if you edit the query with the Query Editor button.

Why we use this feature?

We use this feature to auto-create Query to select sObject data field, and generate auto IStructure in Query Editor.

Using auto create query base on mapping

To auto-create query, you need to follow the steps below:

• After creating integration and interface, enter page detail of interface and scroll down to the Mapping Section. Do Mapping by drag and drop in Data Mapping grid.
• Click Save the mapping field then navigate to SOQL Query to select sObject data section. You will see the fields are auto-generating.

[su_box title="Note" box_color="#2a8af0" title_color="#000000"] Applicable Delete All Mapping and Delete All Query will result:

• When Delete All Mapping, it won't Delete all Query.
• When Delete All Query, it won't Delete all Mapping.

[/su_box]