Go To
- Microsoft Power Automate Community
- Welcome to the Community!
- News & Announcements
- Get Help with Power Automate
- General Power Automate Discussion
- Connecting To Data
- Building Flows
- Using Flows
- Power Automate Desktop
- Process Advisor
- AI Builder
- Power Automate Mobile App
- Translation Quality Feedback
- Connector Development
- Share, Chat, Discuss
- Community Chat & Announcements
- Power Automate Cookbook
- Off Topic Discussion
- Power Platform Integration - Better Together!
- Power Platform Integrations
- Power Platform and Dynamics 365 Integrations
- Watch & Share Videos
- Webinars and Video Gallery
- 2021 MSBizAppsSummit Gallery
- 2020 MSBizAppsSummit Gallery
- 2019 MSBizAppsSummit Gallery
- Give Feedback & Share Ideas
- Power Automate Ideas
- Report Issues
- I Found A Bug
- Find & Join Local User Groups
- Power Automate User Groups
- Read & Share Blogs
- Power Automate Community Blog
- Community Blog Topic Suggestions
- Community Support
- Community Accounts & Registration
- Using the Community
- Community Feedback
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Microsoft Power Automate Community
- Forums
- Get Help with Power Automate
- Building Flows
- "PARSE JSON" action fails to accept very data it u...
Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
"PARSE JSON" action fails to accept very data it used and approved to build the schema.
09-25-2020
12:59 PM
I am trying to use the "PARSE JSON" action to parse incoming JSON data from an API. I took incoming JSON and used it to "generate" its own schema which is an available option in the action. However, it seems to reject the identical JSON it considered valid enough to build a schema. The error is : "The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value 'Parse ACES Export JSON' cannot be parsed: 'Unexpected character encountered while parsing value: P. Path '', line 0, position 0.'."
Here is the source JSON (Edited to remove sensitive data) which was the exact JSON used to generate schema:
{
"statusCode": 200,
"headers": {
"Pragma": "public",
"Transfer-Encoding": "chunked",
"Vary": "Authorization,User-Agent",
"Strict-Transport-Security": "max-age=31536000; includeSubdomains;",
"X-Content-Type-Options": "nosniff",
"Cache-Control": "must-revalidate, post-check=0, pre-check=0",
"Date": "Fri, 25 Sep 2020 17:19:27 GMT",
"Content-Type": "application/json",
"Expires": "0",
"Content-Length": "31687"
},
"body": {
"title": "aces_export",
"fields": [
{
"id": "employeeNumber",
"type": "employee_number",
"name": "reference_number"
},
{
"id": "workEmail",
"type": "email",
"name": "email"
},
{
"id": "firstName",
"type": "text",
"name": "first_name"
},
{
"id": "lastName",
"type": "text",
"name": "last_name"
},
{
"id": "gender",
"type": "gender",
"name": "gender"
},
{
"id": "supervisorId",
"type": "text",
"name": "approver"
},
{
"id": "terminationDate",
"type": "date",
"name": "leaving_date"
},
{
"id": "department",
"type": "list",
"name": "department"
},
{
"id": "division",
"type": "list",
"name": "division"
},
{
"id": "jobTitle",
"type": "list",
"name": "job_title"
}
],
"employees": [
{
"id": "200",
"employeeNumber": "5340",
"workEmail": "bob@apple.com",
"firstName": "Bob",
"lastName": "Barker",
"gender": "Male",
"supervisorId": "5154",
"terminationDate": "0000-00-00",
"department": "Broadcast",
"division": "GameShow",
"jobTitle": "Host"
}
]
}
}
and here is the schema that is generated by PARSE JSON:
"statusCode": {
"type": "integer"
},
"headers": {
"type": "object",
"properties": {
"Pragma": {
"type": "string"
},
"Transfer-Encoding": {
"type": "string"
},
"Vary": {
"type": "string"
},
"Strict-Transport-Security": {
"type": "string"
},
"X-Content-Type-Options": {
"type": "string"
},
"Cache-Control": {
"type": "string"
},
"Date": {
"type": "string"
},
"Content-Type": {
"type": "string"
},
"Expires": {
"type": "string"
},
"Content-Length": {
"type": "string"
}
}
},
"body": {
"type": "object",
"properties": {
"title": {
"type": "string"
},
"fields": {
"type": "array",
"items": {
"type": "object",
"properties": {
"id": {
"type": "string"
},
"type": {
"type": "string"
},
"name": {
"type": "string"
}
},
"required": [
"id",
"type",
"name"
]
}
},
"employees": {
"type": "array",
"items": {
"type": "object",
"properties": {
"id": {
"type": "string"
},
"employeeNumber": {
"type": "string"
},
"workEmail": {
"type": "string"
},
"firstName": {
"type": "string"
},
"lastName": {
"type": "string"
},
"gender": {
"type": "string"
},
"supervisorId": {
"type": "string"
},
"terminationDate": {
"type": "string"
},
"department": {
"type": "string"
},
"division": {
"type": "string"
},
"jobTitle": {
"type": "string"
}
},
"required": [
"id",
"employeeNumber",
"workEmail",
"firstName",
"lastName",
"gender",
"supervisorId",
"terminationDate",
"department",
"division",
"jobTitle"
]
}
}
}
}
}
}
Any help would be appreciated. I also would like help understanding what is being referred to by "P. Path '', line 0, position 0.'."" would be helpful.
Thank You
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-02-2020
02:39 AM
Please use the below schema
I made a test on your supplied JSON above with the below Schema and it worked fine
{
"$schema": "http://json-schema.org/draft-07/schema",
"$id": "http://example.com/example.json",
"type": "object",
"title": "The root schema",
"description": "The root schema comprises the entire JSON document.",
"default": {},
"examples": [
{
"statusCode": 200,
"headers": {
"Pragma": "public",
"Transfer-Encoding": "chunked",
"Vary": "Authorization,User-Agent",
"Strict-Transport-Security": "max-age=31536000; includeSubdomains;",
"X-Content-Type-Options": "nosniff",
"Cache-Control": "must-revalidate, post-check=0, pre-check=0",
"Date": "Fri, 25 Sep 2020 17:19:27 GMT",
"Content-Type": "application/json",
"Expires": "0",
"Content-Length": "31687"
},
"body": {
"title": "aces_export",
"fields": [
{
"id": "employeeNumber",
"type": "employee_number",
"name": "reference_number"
},
{
"id": "workEmail",
"type": "email",
"name": "email"
},
{
"id": "firstName",
"type": "text",
"name": "first_name"
},
{
"id": "lastName",
"type": "text",
"name": "last_name"
},
{
"id": "gender",
"type": "gender",
"name": "gender"
},
{
"id": "supervisorId",
"type": "text",
"name": "approver"
},
{
"id": "terminationDate",
"type": "date",
"name": "leaving_date"
},
{
"id": "department",
"type": "list",
"name": "department"
},
{
"id": "division",
"type": "list",
"name": "division"
},
{
"id": "jobTitle",
"type": "list",
"name": "job_title"
}
],
"employees": [
{
"id": "200",
"employeeNumber": "5340",
"workEmail": "bob@apple.com",
"firstName": "Bob",
"lastName": "Barker",
"gender": "Male",
"supervisorId": "5154",
"terminationDate": "0000-00-00",
"department": "Broadcast",
"division": "GameShow",
"jobTitle": "Host"
}
]
}
}
],
"required": [
"statusCode",
"headers",
"body"
],
"properties": {
"statusCode": {
"$id": "#/properties/statusCode",
"type": "integer",
"title": "The statusCode schema",
"description": "An explanation about the purpose of this instance.",
"default": 0,
"examples": [
200
]
},
"headers": {
"$id": "#/properties/headers",
"type": "object",
"title": "The headers schema",
"description": "An explanation about the purpose of this instance.",
"default": {},
"examples": [
{
"Pragma": "public",
"Transfer-Encoding": "chunked",
"Vary": "Authorization,User-Agent",
"Strict-Transport-Security": "max-age=31536000; includeSubdomains;",
"X-Content-Type-Options": "nosniff",
"Cache-Control": "must-revalidate, post-check=0, pre-check=0",
"Date": "Fri, 25 Sep 2020 17:19:27 GMT",
"Content-Type": "application/json",
"Expires": "0",
"Content-Length": "31687"
}
],
"required": [
"Pragma",
"Transfer-Encoding",
"Vary",
"Strict-Transport-Security",
"X-Content-Type-Options",
"Cache-Control",
"Date",
"Content-Type",
"Expires",
"Content-Length"
],
"properties": {
"Pragma": {
"$id": "#/properties/headers/properties/Pragma",
"type": "string",
"title": "The Pragma schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"public"
]
},
"Transfer-Encoding": {
"$id": "#/properties/headers/properties/Transfer-Encoding",
"type": "string",
"title": "The Transfer-Encoding schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"chunked"
]
},
"Vary": {
"$id": "#/properties/headers/properties/Vary",
"type": "string",
"title": "The Vary schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"Authorization,User-Agent"
]
},
"Strict-Transport-Security": {
"$id": "#/properties/headers/properties/Strict-Transport-Security",
"type": "string",
"title": "The Strict-Transport-Security schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"max-age=31536000; includeSubdomains;"
]
},
"X-Content-Type-Options": {
"$id": "#/properties/headers/properties/X-Content-Type-Options",
"type": "string",
"title": "The X-Content-Type-Options schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"nosniff"
]
},
"Cache-Control": {
"$id": "#/properties/headers/properties/Cache-Control",
"type": "string",
"title": "The Cache-Control schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"must-revalidate, post-check=0, pre-check=0"
]
},
"Date": {
"$id": "#/properties/headers/properties/Date",
"type": "string",
"title": "The Date schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"Fri, 25 Sep 2020 17:19:27 GMT"
]
},
"Content-Type": {
"$id": "#/properties/headers/properties/Content-Type",
"type": "string",
"title": "The Content-Type schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"application/json"
]
},
"Expires": {
"$id": "#/properties/headers/properties/Expires",
"type": "string",
"title": "The Expires schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"0"
]
},
"Content-Length": {
"$id": "#/properties/headers/properties/Content-Length",
"type": "string",
"title": "The Content-Length schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"31687"
]
}
},
"additionalProperties": true
},
"body": {
"$id": "#/properties/body",
"type": "object",
"title": "The body schema",
"description": "An explanation about the purpose of this instance.",
"default": {},
"examples": [
{
"title": "aces_export",
"fields": [
{
"id": "employeeNumber",
"type": "employee_number",
"name": "reference_number"
},
{
"id": "workEmail",
"type": "email",
"name": "email"
},
{
"id": "firstName",
"type": "text",
"name": "first_name"
},
{
"id": "lastName",
"type": "text",
"name": "last_name"
},
{
"id": "gender",
"type": "gender",
"name": "gender"
},
{
"id": "supervisorId",
"type": "text",
"name": "approver"
},
{
"id": "terminationDate",
"type": "date",
"name": "leaving_date"
},
{
"id": "department",
"type": "list",
"name": "department"
},
{
"id": "division",
"type": "list",
"name": "division"
},
{
"id": "jobTitle",
"type": "list",
"name": "job_title"
}
],
"employees": [
{
"id": "200",
"employeeNumber": "5340",
"workEmail": "bob@apple.com",
"firstName": "Bob",
"lastName": "Barker",
"gender": "Male",
"supervisorId": "5154",
"terminationDate": "0000-00-00",
"department": "Broadcast",
"division": "GameShow",
"jobTitle": "Host"
}
]
}
],
"required": [
"title",
"fields",
"employees"
],
"properties": {
"title": {
"$id": "#/properties/body/properties/title",
"type": "string",
"title": "The title schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"aces_export"
]
},
"fields": {
"$id": "#/properties/body/properties/fields",
"type": "array",
"title": "The fields schema",
"description": "An explanation about the purpose of this instance.",
"default": [],
"examples": [
[
{
"id": "employeeNumber",
"type": "employee_number",
"name": "reference_number"
},
{
"id": "workEmail",
"type": "email",
"name": "email"
}
]
],
"additionalItems": true,
"items": {
"$id": "#/properties/body/properties/fields/items",
"anyOf": [
{
"$id": "#/properties/body/properties/fields/items/anyOf/0",
"type": "object",
"title": "The first anyOf schema",
"description": "An explanation about the purpose of this instance.",
"default": {},
"examples": [
{
"id": "employeeNumber",
"type": "employee_number",
"name": "reference_number"
}
],
"required": [
"id",
"type",
"name"
],
"properties": {
"id": {
"$id": "#/properties/body/properties/fields/items/anyOf/0/properties/id",
"type": "string",
"title": "The id schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"employeeNumber"
]
},
"type": {
"$id": "#/properties/body/properties/fields/items/anyOf/0/properties/type",
"type": "string",
"title": "The type schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"employee_number"
]
},
"name": {
"$id": "#/properties/body/properties/fields/items/anyOf/0/properties/name",
"type": "string",
"title": "The name schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"reference_number"
]
}
},
"additionalProperties": true
}
]
}
},
"employees": {
"$id": "#/properties/body/properties/employees",
"type": "array",
"title": "The employees schema",
"description": "An explanation about the purpose of this instance.",
"default": [],
"examples": [
[
{
"id": "200",
"employeeNumber": "5340",
"workEmail": "bob@apple.com",
"firstName": "Bob",
"lastName": "Barker",
"gender": "Male",
"supervisorId": "5154",
"terminationDate": "0000-00-00",
"department": "Broadcast",
"division": "GameShow",
"jobTitle": "Host"
}
]
],
"additionalItems": true,
"items": {
"$id": "#/properties/body/properties/employees/items",
"anyOf": [
{
"$id": "#/properties/body/properties/employees/items/anyOf/0",
"type": "object",
"title": "The first anyOf schema",
"description": "An explanation about the purpose of this instance.",
"default": {},
"examples": [
{
"id": "200",
"employeeNumber": "5340",
"workEmail": "bob@apple.com",
"firstName": "Bob",
"lastName": "Barker",
"gender": "Male",
"supervisorId": "5154",
"terminationDate": "0000-00-00",
"department": "Broadcast",
"division": "GameShow",
"jobTitle": "Host"
}
],
"required": [
"id",
"employeeNumber",
"workEmail",
"firstName",
"lastName",
"gender",
"supervisorId",
"terminationDate",
"department",
"division",
"jobTitle"
],
"properties": {
"id": {
"$id": "#/properties/body/properties/employees/items/anyOf/0/properties/id",
"type": "string",
"title": "The id schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"200"
]
},
"employeeNumber": {
"$id": "#/properties/body/properties/employees/items/anyOf/0/properties/employeeNumber",
"type": "string",
"title": "The employeeNumber schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"5340"
]
},
"workEmail": {
"$id": "#/properties/body/properties/employees/items/anyOf/0/properties/workEmail",
"type": "string",
"title": "The workEmail schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"bob@apple.com"
]
},
"firstName": {
"$id": "#/properties/body/properties/employees/items/anyOf/0/properties/firstName",
"type": "string",
"title": "The firstName schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"Bob"
]
},
"lastName": {
"$id": "#/properties/body/properties/employees/items/anyOf/0/properties/lastName",
"type": "string",
"title": "The lastName schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"Barker"
]
},
"gender": {
"$id": "#/properties/body/properties/employees/items/anyOf/0/properties/gender",
"type": "string",
"title": "The gender schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"Male"
]
},
"supervisorId": {
"$id": "#/properties/body/properties/employees/items/anyOf/0/properties/supervisorId",
"type": "string",
"title": "The supervisorId schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"5154"
]
},
"terminationDate": {
"$id": "#/properties/body/properties/employees/items/anyOf/0/properties/terminationDate",
"type": "string",
"title": "The terminationDate schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"0000-00-00"
]
},
"department": {
"$id": "#/properties/body/properties/employees/items/anyOf/0/properties/department",
"type": "string",
"title": "The department schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"Broadcast"
]
},
"division": {
"$id": "#/properties/body/properties/employees/items/anyOf/0/properties/division",
"type": "string",
"title": "The division schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"GameShow"
]
},
"jobTitle": {
"$id": "#/properties/body/properties/employees/items/anyOf/0/properties/jobTitle",
"type": "string",
"title": "The jobTitle schema",
"description": "An explanation about the purpose of this instance.",
"default": "",
"examples": [
"Host"
]
}
},
"additionalProperties": true
}
]
}
}
},
"additionalProperties": true
}
},
"additionalProperties": true
}
If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.
Blog: here
Blog: here
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-06-2020
03:39 PM
Thanks, I think i might see the issue now.
Paul
Helpful resources
Announcements
Community Challenge - Giveaways!
Participate in the Power Virtual Agents Community Challenge
2021 Release Wave 2 Plan
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Microsoft Learn
Check out our new Discover Your Career Path blog post series and get all the details.
Top Solution Authors
| User | Count |
|---|---|
| 37 | |
| 30 | |
| 30 | |
| 26 | |
| 20 |
Top Kudoed Authors
| User | Count |
|---|---|
| 53 | |
| 42 | |
| 38 | |
| 34 | |
| 28 |
Users online (924)
