ServiceNow linked service in Azure Data Factory (ADF) allows you to connect to your ServiceNow instance and perform data operations. Here are the steps to inject data ranges and limit rows:
1. **Create a ServiceNow Linked Service in ADF**:
- Navigate to the ADF portal and create a new linked service.
- Select ServiceNow from the list of data stores.
- Provide your ServiceNow instance details and credentials.
2. **Inject Data Ranges**:
- You can use the sysparm_query parameter to filter data based on date ranges.
- For example, to filter records created after a specific date, you can use sysparm_query=sys_created_on>javascript:gs.dateGenerate('yyyy-mm-dd','hh:mm:ss').
- Replace 'yyyy-mm-dd' and 'hh:mm:ss' with your desired date and time.
3. **Limit Rows**:
- You can limit the number of rows returned by using the sysparm_limit parameter.
- For example, to limit the result to 100 rows, you can use sysparm_limit=100.
4. **Inject these parameters in ADF**:
- In ADF, when creating a new dataset for ServiceNow, you can specify these parameters in the 'Relative URL' field.
- For example, /table_name?sysparm_query=sys_created_on>javascript:gs.dateGenerate('yyyy-mm-dd','hh:mm:ss')&sysparm_limit=100.
- Replace 'table_name' with the name of your ServiceNow table.
Please note that the actual implementation might vary based on your specific requirements and ServiceNow instance configuration. Always test your queries in a controlled environment before applying them to production data.
nowKB.com
If you want to know any information about Service Now . Visit to https://nowkb.com/home
