Hi @Newbie Cdata 

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 [email protected] 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 @Newbie Cdata,

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.

Thanks Ethem Q for the timely response.