Querying from ADF to Servicenow

Question

Hi

I have created a connection from ADF to Service Now. But when I am trying to query the data during a Copy Activity , it fails with time out issues. I want to use the functions like year(column_name) on the source(Snow). But I could not find a documentation of these functions. Where do I have this documentation.?

Answer 1

Hello @Krishnamohan Nadimpalli,

Could you please add more info on your Source dataset, how does it look when you do 'Preview Data' in ADF?

Please attach some screenshots of your ADF pipeline with exact requirement or what your are trying to resolve?

Here's how you can use the ServiceNow Query Builder to construct a query that uses the year() function:

1. Open the ServiceNow Query Builder by navigating to the "System Definition" > "Tables" menu in ServiceNow and selecting the table that you want to query.
2. Click on the "Query" button to open the Query Builder.
3. Drag the column that you want to filter on to the "Filter" section of the Query Builder.
4. Click on the "Function" dropdown and select "year".
5. Enter the column name as the argument to the year() function.
6. Enter the year that you want to filter on in the "Value" field.
7. Click on the "Run" button to execute the query and view the results.

Once you have constructed your query using the Query Builder, you can use it in your Azure Data Factory pipeline to retrieve data from ServiceNow and copy it to your destination.
If the response is helpful, please click "Accept Answer" and Click 'Yes'. So that we can close this thread.