REST API - "Error: Request is not valid JSON" Status Code: 400

[Akanksha_Varshney]

Hi UIPathians,

After reading through tons of posts on REST API calls on the forum, still unable to figure out a reason for the error am facing.

Am trying to POST a REST request and the workflow looks like as below:

After going through many posts here, have tried with following values in the Body part till now:

1. Single Quotes:
   “{“‘default_phone_number”‘:null,”‘password”‘: “‘1234”‘,”‘email”‘:”‘av@av.com”‘,”‘first_name”‘:”‘Joe”‘,”‘is_admin”‘: True,”‘last_name”‘:”‘Admin”‘,”‘permissions”‘:{“‘edit_apps”‘:True,”‘edit_cc_users”‘:True,”‘edit_data”‘:True,”‘edit_web_users”‘:True,”‘view_report_list”‘:,”‘view_reports”‘:True},”‘phone_numbers”‘:,”‘role”‘:”‘Admin”‘,”‘username”‘:”‘av2@av.com”‘}”

2. Double Quotes, ecaped:
   “{““default_phone_number”“:null,““password”“: ““1234”“,““email”“:”“av@av.com”“,““first_name”“:”“Joe”“,““is_admin”“: True,““last_name”“:”“Admin”“,““permissions”“:{““edit_apps”“:True,““edit_cc_users”“:True,““edit_data”“:True,““edit_web_users”“:True,““view_report_list”“:,““view_reports”“:True},““phone_numbers”“:,““role”“:”“Admin”“,““username”“:”“av@av.com”“}”

3. Only Single Quotes:
   “{‘default_phone_number’:null,’password’: ‘qwer1234’,’email’:’av1@avtest.com’,’first_name’:’Joe’,’is_admin’: True,’last_name’:’Admin’,’permissions’:{‘edit_apps’:True,’edit_commcare_users’:True,’edit_data’:True,’edit_web_users’:True,’view_report_list’:,’view_reports’:True},’phone_numbers’:,’role’:’Admin’,’username’:’av1@avtest.com’}”

All yield same error: “Error: Request is not valid JSON” Status Code: 400

An help on this is highly appreciated.
Thanks!

@ovi
@badita
@aksh1yadav

[Akash_N_Jain (Akash Jain)]

@Akanksha_Varshney

“{“‘default_phone_number”‘:null,”‘password”‘: “‘1234”‘,”‘email”‘:”‘av@av.com”‘,”‘first_name”‘:”‘Joe”‘,”‘is_admin”‘: True,”‘last_name”‘:”‘Admin”‘,”‘permissions”‘:{“‘edit_apps”‘:True,”‘edit_cc_users”‘:True,”‘edit_data”‘:True,”‘edit_web_users”‘:True,”‘view_report_list”‘:,”‘view_reports”‘:True},”‘phone_numbers”‘:,”‘role”‘:”‘Admin”‘,”‘username”‘:”‘av2@av.com”‘}”

Check for JSON validator using various website available one of them - https://jsonformatter.curiousconcept.com, https://jsonlint.com/… I tried one of your JSON and got the error invalid JSON

[Akanksha_Varshney]

@Akanksha_Varshney

{‘default_phone_number’:null,’password’: ‘qwer1234’,’email’:’av1@avtest.com’,’first_name’:’Joe’,’is_admin’: True,’last_name’:’Admin’,’permissions’:{‘edit_apps’:True,’edit_commcare_users’:True,’edit_data’:True,’edit_web_users’:True,’view_report_list’:,’view_reports’:True},’phone_numbers’:,’role’:’Admin’,’username’:’av1@avtest.com’}

Thanks for looking into, @Akash_N_Jain!
I looked into the formatter and it gives same error for all the three varieties " [Strings should be wrapped in double quotes.](javascript:;)"

Also, the format in which UiPath accepts the JSON is different from normal JSON format. Any way to validate the former?

[Akash_N_Jain (Akash Jain)]

Sample JSON - {
“Enabled”: true,

 "Name": "HelloTrigger11",

 "ReleaseId": 26471,

 "ReleaseKey": "66d493f1-080b-428d-821e-ba4e460ddb",

 "ReleaseName": "helloLog_hello",

 "PackageName": "helloLog",

 "EnvironmentName": "hello",

 "EnvironmentId": "16584",

 "StartProcessCron": "0 0 0/1 1/1 * ? *",

 "StartProcessCronDetails": "{\"type\":1,\"minutely\":{},\"hourly\":{\"atMinute\":0,\"frequencyInHours\":\"1\"},\"daily\":{},\"weekly\":{\"weekdays\":[]},\"monthly\":{\"weekdays\":[]},\"advancedCronExpression\":\"\"}",

 "StartProcessCronSummary": "Every hour",

 "StartProcessNextOccurrence": "2018-08-02T07:30:00Z",

 "StartStrategy": -1,

 "StopProcessExpression": "",

 "StopStrategy": null,

 "ExternalJobKey": null,

 "TimeZoneId": "India Standard Time",

 "TimeZoneIana": "Asia/Calcutta",

 "Id": 0

}

[Akanksha_Varshney]

@Akash_N_Jain

“Enabled”: true

@Akash_N_Jain
Same error!
Is this something that should be entered explicitly? Does it mean something I don’t know?

[Akash_N_Jain (Akash Jain)]

Nopes that was required for the JSON that i was forming

[Akanksha_Varshney]

okay!
so am still unable to get rid of the error…

[Akanksha_Varshney]

@ovi @ClaytonM @badita

[Akash_N_Jain (Akash Jain)]

@Akanksha_Varshney

“{‘default_phone_number’:null,’password’: ‘qwer1234’,’email’:’av1@avtest.com’,’first_name’:’Joe’,’is_admin’: True,’last_name’:’Admin’,’permissions’:{‘edit_apps’:True,’edit_commcare_users’:True,’edit_data’:True,’edit_web_users’:True,’view_report_list’:,’view_reports’:True},’phone_numbers’:,’role’:’Admin’,’username’:’av1@avtest.com’}”

Have corrected one of your JSON & it shows as valid now:
{
“default_phone_number”: null,
“password”: “qwer1234”,
“email”: “av1 @avtest.com”,
“first_name”: “Joe”,
“is_admin”: “True”,
“last_name”: “Admin”,
“permissions”: {
"edit_apps ": "True ",
“edit_commcare_users”: “True”,
“edit_data”: “True”,
“edit_web_users”: “True”,
“view_report_list”: null,
“view_reports”: “True”
},
“phone_numbers”: null,
“role”: “Admin”,
“username”: “av1 @avtest.com”
}

[Akash_N_Jain (Akash Jain)]

I observed lot of random quotation marks used in JSON. When you try to validate the JSON on online please follow the error message that it shows which will help you in resolving the same.

[Akanksha_Varshney]

Hey @Akash_N_Jain,
Thanks for helping out.
The thing is, JSON format used in normal tools like Postman does not work in UiPath.

[ClaytonM]

@Akanksha_Varshney
Hi. Don’t know if this helps, but sometimes when you copy text with quotations it copies a different character for the quotation marks and so it doesn’t work in UiPath. Try replacing all the quotation marks manually, because it should create “strings” in colored text within the Expression editor.

[Akanksha_Varshney]

Hi @ClaytonM,

Thanks for the inputs!
I have tried the string even by manually replacing all the quotes but still get the error as “Invalid JSON”

Any other thoughts on this?
Thanks!

[roma.sodha]

Hi Akansha,

Did you solve the issue, because I am also facing same issue?

[Akanksha_Varshney]

Hey @roma.sodha,
Yes, I was able to solve this by putting the whole JSON in a JSON file and reading the same. Reading an external makes it convenient for UiPath to figure out the best way to deal with quotes.
Let me know in case of further questions.
Thanks!

[roma.sodha]

Can you send me sample workflow working?

[Akanksha_Varshney]

Hey @roma.sodha,

The message got missed somehow.
Please find attached a sample json file.
Would be glad if it still helps!

Request_Body.json (549 Bytes)

[Imran_Shaw]

I am trying to put a filter in the body of the request. unfortunately, its not working for me. so far I tried double quotes 2x and single quotes. I just discovered this post about creating the json file. Did you put the file path of the json file in the request body field?

[Cristian_Negulescu]

Hello Imran,
In this video I work with a complex JSON:

How to work with issues via REST API from UiPath Studio (Download all attachments)

Thanks,
Cristian Negulescu

[keerthana.sundarraj]

Hi @Akanksha_Varshney ,

I have validated my json and it says its valid , but when i post it as attachment .json file it gives me same error . can you please help me how to fix this
{
“message”: “Error\n

Error

\nInvalid JSON message content used; Message: "Input is not valid JSON at character 45 of -------------------------------28947758029299\r\nContent-Disposition: form-data; name="json"\r\n\r\njson\r\n-------------------------------28947758029299\r\nContent-Disposition: form-data; name="jsonfile"; filename="ABBY_APAutomation.json"\r\nContent-Type: application/octet-stream\r\n\r\n{\r\n\t"HEADERDATA": {\r\n\t\t"INVOICE_IND": "",\r\n\t\t"DOC_DATE": "",\r\n\t\t"PSTNG_DATE": "",\r\n\t\t"REF_DOC_NO": "",\r\n\t\t"COMP_CODE": "",\r\n\t\t"DIFF_INV": "",\r\n\t\t"CURRENCY_ISO": "",\r\n\t\t"GROSS_AMOUNT": "",\r\n\t\t"CALC_TAX_IND": "",\r\n\t\t"HEADER_TXT": "",\r\n\t\t"DEL_COSTS": "",\r\n\t\t"PYMT_METH": "",\r\n\t\t"ALLOC_NMBR": "",\r\n\t\t"INV_REF_NO": "",\r\n\t\t"INV_YEAR": "",\r\n\t\t"BUS_AREA": "",\r\n\t\t"ITEM_TEXT": "",\r\n\t\t"BUSINESS_PLACE": "",\r\n\t\t"GST_PART": "",\r\n\t\t"PLC_SUP": "",\r\n\t\t"IRN": ""\r\n\t},\r\n\t"WITHTAXDATA": {\r\n\t\t"SPLIT_KEY": "",\r\n\t\t"WI_TAX_TYPE": "",\r\n\t\t"WI_TAX_CODE": "",\r\n\t\t"WI_TAX_BASE": "",\r\n\t\t"WI_TAX_AMT": ""\r\n\t},\r\n\t"ITEMDATA": {\r\n\t\t"INVOICE_DOC_ITEM": "",\r\n\t\t"PO_NUMBER": "",\r\n\t\t"PO_ITEM": "",\r\n\t\t"REF_DOC": "",\r\n\t\t"REF_DOC_YEAR": "",\r\n\t\t"REF_DOC_IT": "",\r\n\t\t"SHEET_NO": "",\r\n\t\t"TAX_CODE": "",\r\n\t\t"ITEM_AMOUNT": "",\r\n\t\t"QUANTITY": "",\r\n\t\t"PO_UNIT": "",\r\n\t\t"COND_TYPE": "",\r\n\t\t"ITEM_TEXT": "",\r\n\t\t"HSN_SAC": ""\r\n\t},\r\n\t"GLACCOUNTDATA": {\r\n\t\t"INVOICE_DOC_ITEM": "",\r\n\t\t"GL_ACCOUNT": "",\r\n\t\t"ITEM_AMOUNT": "",\r\n\t\t"DB_CR_IND": "",\r\n\t\t"COMP_CODE": "",\r\n\t\t"TAX_CODE": "",\r\n\t\t"ITEM_TEXT": "",\r\n\t\t"COSTCENTER": "",\r\n\t\t"ORDERID": "",\r\n\t\t"BUS_AREA": "",\r\n\t\t"ALLOC_NMBR": ""\r\n\t},\r\n\t"MATERIALDATA": {\r\n\t\t"INVOICE_DOC_ITEM": "",\r\n\t\t"MATERIAL": "",\r\n\t\t"VAL_AREA": "",\r\n\t\t"DB_CR_IND": "",\r\n\t\t"ITEM_AMOUNT": "",\r\n\t\t"QUANTITY": "",\r\n\t\t"BASE_UOM": "",\r\n\t\t"TAX_CODE": ""\r\n\t},\r\n\t"LINKATTACHMENT": {\r\n\t\t"OBJCONT": "",\r\n\t\t"OBJDES": "abc",\r\n\t\t"__text": "2"\r\n\t},\r\n\t"_xmlns:ns0": "http://pvmgrp.com/fico/in/apautomation\“\r\n}\r\n-------------------------------28947758029299--\”\n

\n500”,
“level”: “Information”,
“logType”: “User”,
“timeStamp”: “09:57:10”,
“processVersion”: “1.0.0”,
“jobId”: “4363c1d7-9737-48db-aac7-802b5d3a25d3”,
“robotName”: “Accounts_Payable”,
“machineId”: 12,
“organizationUnitId”: 1
}