Cannot Fetch a Complete Response While Performing Query Information and Create or Update Information Operations

You may be unable to fetch a complete response while performing Query Information and Create or Update Information operations.

When you perform the Query Information operation in an invoke connection, you may encounter blank results for fields of a reference datatype. See Invoke Operations Page.

Similarly, when you perform the Create or Update Information operation, values against the fields of a reference datatype are inserted/updated in the ServiceNow application. However, the response payload in Oracle Integration fetches blank results for these fields. This may cause an error if you add further endpoints. See Invoke Operations Page.

This typically occurs because you have not given the required permissions to the sys_dictionary table. Therefore, ensure that you set the required permissions, refresh your integration's endpoints, and remap the fields of a reference datatype in the mapper.

You can then fetch accurate and complete information in the response payload.

To set permissions, see Prerequisites for Creating a Connection.