SAP Cloud Platform Open Connectors

Using the OCNQL Query Override Field

SAP Cloud Platform Open Connectors provides a query override field for any connectors whose native search specifications are different from the standard fields implemented on the resource in SAP Cloud Platform Open Connectors. For example, if you are using the Hubspot Marketing connector and want to search for a customer's email, you would query on person.email, as opposed to simply "email," a more commonly used field. This means that when mapping Hubspot Marketing fields in a transformation, you must override the EMAIL field with PERSON.EMAIL in order to successfully use the search; otherwise, you will receive an invalid expression type error.

If the Query Field Name is left blank, the mapped field value will be used. 

To use the query override field with a CO, complete these steps:

  1. Log in to SAP Cloud Platform Open Connectors and click Common Resources.
  2. On the My Resources tab, hover over the CO and click Mappings.
  3. On the Mappings tab, find the field whose name you want to override and click the Field Settings button.
  4. On the Field Settings drawer, enter the overriding value to query at the endpoint in the Query Field Name field, and then click Save.
  5. To test the query override, click the Try It Out button.

Known Connectors

All elements support the OCNQL query override field. However, some connectors may need to use it more frequently than others based on the naming of their fields. See the connector's documentation for additional information.