Process Builder Procedures / Dynamics CRM |
Use the SQL Query activity to create a simple SQL query, and get the records from one entity for Dynamics CRM.
To create a SQL query to get records from Dynamics CRM, do the procedure in this topic.
To create a new access token, click Add Token . For more information, refer to New Dynamics CRM Access Token.
Field Name | Definition |
---|---|
Configured Column Fields |
Use the right arrow button to move the selected fields from the Entity Column Fields list to the Configured Column Fields list. To select more than one field, press and hold the Ctrl key when you click the field names. |
Example:
Field Name | Value |
---|---|
Column |
accountid |
Comparer |
Equal |
Value |
123 |
Select accountcategorycode, accountcategorycodename, accountid from Account where accountid Equal '123'