Skip to main content
Conga Support

Build Your Conga Query to Retrieve External Data

This page applies to: Conga Composer Enterprise Edition

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:
https://<your-domain>.com/yourODataEndpoint/Products?$orderby=Name&$format=json

  1. Navigate to the Conga Queries tab
  2. Click New
  3. 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

  4. Click Save.

Repeat steps 1 – 4 for each OData query you’d like to integrate.