We are currently using cdata version .NET Edition - 23.3.8700.0 in our organization and we create jobs through API call. Through API call we are able to create the JOB fine, but we are unable to set StoresUppercaseIdentifiers=true Additional Options property.
Any help on this topic is greatly appreciated.
Hi
In order to set any properties in the AdditionalOptions for your Job in Sync when using the API, you will need to specify the OtherCacheOptions as an input and pass the settings of your choice as values in the body of the request. See example below for reference:
Once you have done this, you should see the setting applied on the AdditionalOptions for your Job in Sync.
In case you keep having issues with this, feel free to reach out to our support team at support@cdata.com and our team will assist you further.
Thanks Ethem Q for your feedback.
I have one more question. When we create a CData job through API is there an way we can exclude few columns on a table which is part of the job?
Hi
Excluding columns from a selected table is not something we support directly. The only way to get the columns of your choice when using the API would be to pass the Query where you define only the columns that you need as the parameter using the Tasks endpoint. See example below for reference:
Running the above would create a table with only the columns you are specifying in the query.
Let us know if you have any other questions.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers