Missing columns from Incident, when copy data from ServiceNow using Azure Data Factory

[cfosund]

Hi,

Azure Data Factory provides a buildt inn connector to ServiceNow that simplifies a copy activity from the ServiceNow REST API. It works great, and allows us to easily copy data to Azure SQL and other sources.
More info:
https://docs.microsoft.com/en-us/azure/data-factory/connector-servicenow

The problem we are experiencing is that not all columns are available in the tables.

The ACTUAL.Incident table is missing service_offering and few other columns.
Is this a know issue, and are anyone else experiencing the same issue?

We see the service_offering column when accessing the Incident table through the REST API with a webbrowser.
But not when using the connector in Azure Data Factory.

Thanks

[Chuck Tomasi]

Are you using the same credentials on both Azure and your test? If not, it could be ACL related - e.g. the account you are using doesn't have read access to that field.

[cfosund]

Hi,

Yes I'm using the same credentials in Azure Data Factory as with the REST API.
I see the column when using the REST API, but not when using the same account in Azure Data Factory.

[edgarsosa]

I have the same problem with extended field within the incident table any workaround so far??

[John43]

I am new to SN.  I too am using the MS Data Factory ServiceNow connector, and finding that there are missing columns in either the Actual or Display tables.  For example, I cannot find "u_behalf_of_user" field.

Any update/acknowledgement this is a known issue would be greatly appreciate.

Any workaround would too be appreciated.