Update OOB Table API

[Cirrus]

Good afternoon,

Wondering if anyone can advise if this is possible, and if so how.

On our sys_user table we have a custom_id field which we use as an identifier for a custom web application. We now want these users to be able to submit cases from the web. In most cases a simple rest api call is sufficient, but when we have two users with the same name it cannot recognise which user it is. On the application side, we can extract the user name and the custom id (email is not available) but in order to lookup the user via rest api on the case table we need to query both name and custom id. Currently custom id can only be added to the case table as a dot walked field, but it is still not available in the api.

Is there a way to update the oob table api to add a custom field to make it selectable from the 'build' dropdown of fieldnames in rest api explorer??

[Ankur Bawiskar]

@Cirrus 

so the table API end point is on Case table and you want to see the dot walked field in drop-down of rest explorer?

Can you share screenshot

[Cirrus]

Thats exactly it Ankur. In the attached screenshots you can see that we can add the dot walked field to the case form, but if you then try and create a post where tablename is sn_customerservice_case, the field is unavailable in the dropdown list (too big to screenshot)

POST https://subdev1.service-now.com/api/now/table/{tableName}

[Ankur Bawiskar · Accepted solution]

@Cirrus 

you can only create/update field which is on same table on which table API is used.

[Cirrus]

Thanks Ankur