ExecuteCQL
You can execute CQL directly without creating a Saved Query using the following endpoint.
post
https://<Cinchy Web URL>
/API/ExecuteCQL
ExecuteCQL

Parameters

To pass in parameters in your executeCQL, you will need to pass in sets of parameters in the following format. So if you have one parameter then you would pass in 3 query parameters beginning with Parameters[0]. , and if you have a second parameter you would include an additional 3 query parameters beginning with Parameters[1]. .
Query String Parameter Name
Content
Parameters[n].ParameterName
Name of the parameter that is in your query, including the '@'.
Ex. @name
Parameters[n].XmlSerializedValue
XML Serialized version of the value of that parameter.
Ex. &quot;test&quot;
Parameters[n].ValueType
Datatype of the value.
Ex. System.String
Last modified 1yr ago
Copy link