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

[edgarsosa]

I have already reported to Microsoft Support it is a Data Factory bug, the status is still open 

[John43]

Thanks for the update edgarsosa.

I don't suppose you have a link to the MS support item?  It would be helpful when discussing issue with our MS accounts manager.

[vishurajm]

Is there any update on this issue? How can this be fixed?

Regards,
Vishu

[John43]

Hi Vishu

I gave up on the Azure Data Factory ServiceNow connectors. 

I use the more generic HTTP connector and configure this to make API GET calls for each of the SN tables.

Regards

John

[vishurajm]

Yes John, Even i tried the rest connector and configured the table API