# How to set Additional Job Options via API Call **URL:** \ **Category:** CData Sync\ **Tags:** question, api, cdata-sync, configuration\ **Created:** [April 9, 2024, 2:49pm UTC](https://community.cdata.com/t/how-to-set-additional-job-options-via-api-call/690 "2024-04-09T14:49:44Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Newbie\_Cdata](https://avatars.discourse-cdn.com/v4/letter/n/46a35a/32.png) [@Newbie\_Cdata](https://community.cdata.com/u/Newbie_Cdata)\ **Post date:** [April 9, 2024, 2:49pm UTC](https://community.cdata.com/t/how-to-set-additional-job-options-via-api-call/690/1 "2024-04-09T14:49:45Z")
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. ---
**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\ **Post date:** [April 9, 2024, 5:27pm UTC](https://community.cdata.com/t/how-to-set-additional-job-options-via-api-call/690/2 "2024-04-09T17:27:57Z")
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: ![575f8149-818f-4e86-9f30-777084e4f3e6.png](https://us1.discourse-cdn.com/cdata/original/1X/0a8778e47894102bf3a3f2d778269a1e518e9054.png) 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](mailto:support@cdata.com) and our team will assist you further. ---
**Author:** ![Newbie\_Cdata](https://avatars.discourse-cdn.com/v4/letter/n/46a35a/32.png) [@Newbie\_Cdata](https://community.cdata.com/u/Newbie_Cdata)\ **Post date:** [April 9, 2024, 5:32pm UTC](https://community.cdata.com/t/how-to-set-additional-job-options-via-api-call/690/3 "2024-04-09T17:32:50Z")
Thanks [Ethem Q](https://community.cdata.com/members/ethem-q-59) 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? ---
**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\ **Post date:** [April 9, 2024, 8:12pm UTC](https://community.cdata.com/t/how-to-set-additional-job-options-via-api-call/690/4 "2024-04-09T20:12:00Z")
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: ![962271b7-7e4c-42f1-95d1-81579e75bfda.png](https://us1.discourse-cdn.com/cdata/original/1X/dd65f6329b858b1dd2d311a3939316433526bed0.png) 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. ---
**Author:** ![Newbie\_Cdata](https://avatars.discourse-cdn.com/v4/letter/n/46a35a/32.png) [@Newbie\_Cdata](https://community.cdata.com/u/Newbie_Cdata)\ **Post date:** [April 9, 2024, 8:50pm UTC](https://community.cdata.com/t/how-to-set-additional-job-options-via-api-call/690/5 "2024-04-09T20:50:55Z")
Thanks [Ethem Q](https://community.cdata.com/members/ethem-q-59) for the timely response.