Servicenow api failure when getting data from timework table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2024 08:52 PM
Hi All,
We are fetching TimeWork data from ServiceNow using api into datawarehouse. The recent Error when we are pulling data I am facing is as below.
An error occurred with the following error message: "An error occurred processing calling url
Error was Invalid character after parsing property name. Expected ':' but got: }. Path 'result', line 1, position 1004624.".
I have spent a lot of time on this but could not locate the error. Plz help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-08-2024 01:18 AM
Hello @Supriya39
Are you sending any request body in this and also give me more explanation about this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-08-2024 01:24 AM
When I do Get request based on api - "https://XXXXX.servicenow.au.com/api/table/task_time_worked?....."
It was fetching data correctly until we started receiving this error - Error was Invalid character after parsing property name. Expected ':' but got: }. Path 'result', line 1, position 1004624.".
There must be some unexpected character entered but it is hard to find
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-08-2024 01:28 AM
Hello @Supriya39
are you using the table api or any other custom script and all ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-08-2024 01:32 AM
We are using table api through a task factory tool in SSIS for fetching records from servicenow tables.
