I have initialized an array variable that contains 7 JSON objects. I'm trying to parse the information so that I can create sharepoint columns for each jason object. However, I'm getting this error:
The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value cannot be parsed: 'Unexpected character encountered while parsing value: J. Path '', line 0, position 0.'.
Here is my array
[
{
"ColumnType": "Text",
"Title": "Work/Task",
"myBody": "{\r\n '__metadata' :{'type' : 'SP.Field'},\r\n 'FieldTypeKind' : 2,\r\n 'Required': 'true',\r\n 'Title' : 'Work/Task',\r\n 'Description' : 'Task to complete by the new employee'}"
},
{
"ColumnType": "Text",
"Title": "Description",
"myBody": "{\r\n '__metadata' :{'type' : 'SP.Field'},\r\n 'FieldTypeKind' : 3,\r\n 'Required':'true',\r\n 'Title' : 'Description',\r\n 'Description' : 'Brief description of the task or work to complete.'}"
},
{
"ColumnType": "Choice",
"Title": "Complete By",
"myBody": "{\r\n '__metadata' : {'type' : 'SP.FieldChoice'},\r\n 'FieldTypeKind' : 6,\r\n 'Required':'true'\r\n 'Title' : 'Complete By',\r\n 'Choices' : { 'results' : ['First day', 'Second day', 'Week 1', 'Week 2', 'Before 30 days', 'Before 90 days']},\r\n 'Description' : 'Due date by when the work should be completed'}"
},
{
"ColumnType": "Choice",
"Title": "Task Status",
"myBody": "{\r\n '__metadata' : {'type' : 'SP.FieldChoice'},\r\n 'FieldTypeKind' : 6,\r\n 'Required':'true',\r\n 'Title' : 'Task Status',\r\n 'Choices' : { 'results' : ['Completed', 'In Progress', 'Pending', 'Not Completed']},\r\n 'Description' : 'Current status of the item being worked by the employee'}"
},
{
"ColumnType": "Date",
"Title": "Completed Date",
"myBody": "{\r\n '__metadata': {'type': 'SP.FieldDateTime'},\r\n 'FieldTypeKind': 4,\r\n 'Required': 'true',\r\n 'Title': 'Completed Date',\r\n 'Description': 'Date of the completion of the task'}"
},
{
"ColumnType":"People",
"Title": "Mentor/Trainer",
"myBody": "{\r\n '__metadata': {'type':'SP.FieldUser'},\r\n 'FieldTypeKind': 20,\r\n 'Required':'true',\r\n 'Title' : 'Mentor/Trainer',\r\n 'Description' : 'Point of contact to help with the work or task item'}"
},
{
"ColumnType":"Text",
"Title": "Relevant Link",
"myBody": "{\r\n '__metadata': {'type':'SP.Field'},\r\n 'FieldTypeKind': 11,\r\n 'Required':'true',\r\n 'Title' : 'Relevant Link',\r\n 'Description' : 'Helpful link to support the task or work item'}"
}
]
