Reg:DATAWINDOW JSON using ImportJSON
- New
- How-to
-
vinothini rajasekar
- PowerBuilder
- Wednesday, 11 February 2026 02:08 PM UTC
Hi Team,
I tried using ImportJSON with the DATAWINDOW JSON format provided below, but it results in a -5 JSON format error. Kindly guide me on whether the issue is with the JSON structure or if the code needs to be updated.Attached the d_dwc_json image fyr.
lrc_getclient.SendGetRequest(ls_get_url, ls_get_Response)
ll_ret= dw_master.ImportJson(ls_get_Response,ls_error,primary!)
ls_get_Response as follows:
{
"identity": "f4e77b8f-6a6d-4a0a-9f31-6b4c1a8f2a63",
"version": 1,
"platform": "PowerBuilder",
"mapping-method": 0,
"dataobject": {
"name": "d_dwc_json",
"meta-columns": [
{
"name": "status",
"index": 0,
"datatype": "string",
"nullable": 1
},
{
"name": "question",
"index": 1,
"datatype": "string",
"nullable": 0
},
{
"name": "isSameAsUserValue",
"index": 2,
"datatype": "number",
"nullable": 0
},
{
"name": "aiReasoning",
"index": 3,
"datatype": "string",
"nullable": 1
},
{
"name": "aiValue",
"index": 4,
"datatype": "string",
"nullable": 1
},
{
"name": "aiRecommendation",
"index": 5,
"datatype": "number",
"nullable": 0
}
],
"primary-rows": [
{
"row-status": 0,
"columns": {
"status": [ "SUCCESS" ],
"question": [ "generating_process" ],
"isSameAsUserValue": [ 0 ],
"aiReasoning": [ "The generating process description should include more detail about the specific operations or activities that created the waste." ],
"aiValue": [ "TEsting the waste material steam" ],
"aiRecommendation": [ 0 ]
}
}
],
"filter-rows": [],
"delete-rows": [],
"dwchilds": {}
}
}
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.