JSON Parser Step Error - Flow Designer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-26-2020 02:03 AM
Hi,
How do I use JSON parser step in flow designer along with 'REST' response saved as attachment ?
So I am making a Get REST call and saving the JSON response as a .txt attachment in servicenow. I'd like to use JSON parser step after this to parse response saved in the attachment. I'm looking up for the attachment and passing it to JSON parser step. However, it throws an error stating this 'JsonParserOperation failed: Extraction of Complex Object failed: JsonStreamParser[0]: JSON must be an object or an array: '4' com.glide.transform.transformer.exceptions.InvalidStructureException'
Please advise.
- Labels:
-
Event Management
-
Orchestration (ITOM)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-26-2020 02:12 AM
Please refer below links
PARIS INTEGRATIONHUB JSON PARSER AND PAYLOAD BUILDER
Flow designer action, parse JSON rest response
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-26-2020 03:48 AM
Hi Ankur,
I know how both the steps work. I am able to use them if I do not save REST step's response as attachment. However, when I save it as attachment and pass the attachment to JSON Parser step, it throws error.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-26-2020 04:07 AM
Hi,
please share screenshot and script which throws error
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-02-2020 08:33 AM
Hi Ankur,
I've figured this out. It threw error only when I used MID server to make a REST call. Thank you though.