Cinchy Query
Last updated
Was this helpful?
Last updated
Was this helpful?
Cinchy queries are commonly used data sync sources that leverage the platform's Saved Query functionality. For more on creating Saved Queries,
Example Use Case: You want to set up batch sync between a Cinchy Query and a Cinchy Table. You query polls for any unapproved timesheets, out of office requests, or sick hours and, if found, adds them to an "Open Approval Tasks" table.
You can review the parameters that can be found in the info tab below (Image 1).
Title
Mandatory. Input a name for your data sync
Open Approval Tasks
Version
Mandatory. This is a pre-populated field containing a version number for your data sync. You can override it if you wish.
1.0.0
Parameters
The following table outlines the mandatory and optional parameters you will find on the Source tab (Image 2).
The following parameters will help to define your data sync source and how it functions.
Source
Mandatory. Select your source from the drop down menu.
Cinchy Query
Domain
Mandatory. The domain where your source query resides.
Compliance
Table Name
Mandatory. The name of you source query.
Open Tasks
Timeout
Optional. The timeout, in number of seconds, for your source query. If not entered this value will default to 30.
120
Parameters
Click Jobs > Start a Job to begin your sync.
Optional. Review our documentation on for more information about this field.
Optional. Review our documentation on for more information about this field.
The section is where you define which source columns you want to sync in your connection. You can repeat the values for multiple columns.
Configure your
Define your.
Add in your , if required.
Define your .