Hi Expert ,
I am facing challenge in APEX web source modules and not finding any solution. I have created web source modules and it is success. I am getting error when I am designing report on top it. Report is created but displaying error as ":ORA-40597: JSON path expression syntax error ('$."fields@odata."context\u0022"') JZN-00209: Unexpected characters after end of path at position 24"
I have investigated the cause and found that JSON array list as shown in below is failing. If i remove these columns from payload able to get the data.
{
"Region": [
"Subsaharan Africa"
],
"Country": [
"Belize"
],
"Sector": [
"Entrepreneurship",
"Process Optimization",
"Strategy",
"Training/Capacity Building"
]
}
I am getting this below error after executing the web source modules.This is JSON array and it is failing.
If I will remove these columns all data is coming perfect and displaying correctly. Issue with APEX parsing for JSON array what i have understood as of now. It would good if you can help out here.
If i will remove these columns from Payload i am getting success result as shown below.
Could you please help me out to fix the issue. Not sure whether it is issue with APEX.
Kind Regards,
Harish Sharma