This article walks through creating a Conga Query using OData syntax to query your external data sources. Each OData Conga Query you create will be appended to an individual external data source previously created.
Behind the scenes, Conga Composer will combine each OData Endpoint with a Composer OData query to gather your data. The resulting url used to call your OData data source will take the form:
- Navigate to the Conga Queries tab
- Click New
Enter the information for your Conga Query using the following:
Name: A name for this Conga Query.
Description: (Optional) A description for this Conga Query
SOQL Select Statement: This is where your OData query will reside. Use OData query syntax here instead of SOQL. The OData query you enter here will be related to an endpoint when you build your Composer solution in Step 3.
OData Query Example: Products?$orderby=Name&$format=json
Repeat steps 1 – 4 for each OData query you’d like to integrate.