When you publish a Coupa connection in Application Integration, the Actions and Objects appear on the Metadata tab.
Consider the following information when you use specific actions and objects:
•The Get Access Token action gets an access token to authorize all the connection requests. After you generate the access token the first time, you can use it for multiple requests for the duration specified in the client credentials.
•The Query Objects action retrieves multiple records for the specified entity type.
Specify the entity type, such as, accounts, contracts, and suppliers to the query objects. Specify the id property to query the objects by ID.
You can apply filters to query objects by criteria. For example, if you want to apply filters to a po-email that contains an upgrade occurrence with the status is equal to active, use the following snippet as a sample to build a requestBody object:
You can specify the maximum number of returned objects by using the property limit. You can skip the first n objects using the offset property.
By default, Coupa Connector produces a heavy output for the Query Objects action. This can cause performance issues especially when multiple processes run at the same time. Therefore, Informatica recommends that you query fewer fields.
You can configure the property return_object using one of the following options:
- none - All the fields including the nested objects will be returned in the output. This is the default option.
- limited - Only identifiers will be returned in the output.
- shallow - Nested objects will be returned only with identifiers.
If you query a list of objects without specifying the id property, set the return_object to limited for high performance.
•The Create Object action inserts a single record of the specified entity type.
To create an object, specify the entity type and the object list of the specified entity type attributes.
•The Update Object action updates the specified record with the name-value pairs of the parameters included in the request body.
To update an object, specify the entityType, the ID of the entity, and the object list of the specified entity type attributes.
•The Patch Object action patches the specified record with the name-value pairs of the parameters included in the request body.
To patch an object, specify the entity type, the ID of the entity, and the object list of the specified entity type attributes.
•The Delete Object action deletes the specified record from the specified table. When the record is deleted, no output information is returned.
To delete an object, specify the entity type and the ID of the specified entity type.
•The Attach File action attaches a file to an object of the specified entity type. To attach a file to an object, specify the entity type, the ID of the entity, and the file properties, such as {secondaryEntityType} and {secondaryId}.