Solved

How to set Additional Job Options via API Call

  • 9 April 2024
  • 4 replies
  • 56 views

Userlevel 1
Badge

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.

 

 

icon

Best answer by Ethem Q 9 April 2024, 19:27

View original

4 replies

Userlevel 5
Badge

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 support@cdata.com and our team will assist you further.

Userlevel 1
Badge

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? 

Userlevel 5
Badge

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.

Userlevel 1
Badge

Thanks Ethem Q for the timely response.

Reply