1. Matthew Balent
  2. PowerBuilder
  3. Tuesday, 23 March 2021 19:14 PM UTC

Okay, so I have the following JSON:

{
"PATIENT_CASE": [
{
"CaseDate": "03/05/2021",
"NatureofCase": "Abdomen Injury",
"CaseClosed": "No",
"CaseID": 1261106365,
"CenterID": 4716,
"SortDate": "2021/03/05",
"PatientID": 1261070650,
"Hipaa": "No",
"Description": "W/C Injury: Infectious gastroenteritis and colitis, unspecified",
"LocationName": "LocationOne",
"CenterName": "CMC - Little Rock North-AR",
"MarketName": "Rhode Island",
"CaseTypeDescription": "W/C Injury",
"IsOnline": "N"
},
{
"CaseDate": "03/04/2021",
"NatureofCase": "Abdomen Injury",
"CaseClosed": "No",
"CaseID": 24136854,
"CenterID": 1,
"SortDate": "2021/03/04",
"PatientID": 21925661,
"Hipaa": "No",
"Description": "W/C Injury: Infectious gastroenteritis and colitis, unspecified",
"LocationName": "LocationOne",
"CenterName": "CMC - DFW Carrollton-TX",
"MarketName": "Dallas/Ft. Worth",
"CaseTypeDescription": "W/C Injury",
"IsOnline": "N"
}
]

Now I want to import it into an datawindow with the datasource as 'External'  Here is the column definition from the source:

table(column=(type=char(10) updatewhereclause=yes name=casedate dbname="casedate" )
column=(type=char(50) updatewhereclause=yes name=natureofcase dbname="natureofcase" )
column=(type=char(3) updatewhereclause=yes name=caseclosed dbname="caseclosed" )
column=(type=char(20) updatewhereclause=yes name=caseid dbname="caseid" )
column=(type=char(20) updatewhereclause=yes name=centerid dbname="centerid" )
column=(type=char(10) updatewhereclause=yes name=sortdate dbname="sortdate" )
column=(type=char(20) updatewhereclause=yes name=patientid dbname="patientid" )
column=(type=char(3) updatewhereclause=yes name=hipaa dbname="hipaa" )
column=(type=char(250) updatewhereclause=yes name=description dbname="description" )
column=(type=char(45) updatewhereclause=yes name=locationname dbname="locationname" )
column=(type=char(45) updatewhereclause=yes name=centername dbname="centername" )
column=(type=char(45) updatewhereclause=yes name=marketname dbname="marketname" )
column=(type=char(45) updatewhereclause=yes name=casetypedescription dbname="casetypedescription" )
column=(type=char(1) updatewhereclause=yes name=isonline dbname="isonline" )
)

Every time I try the importjson method it returns NULL.  (statement is li_rc = ldw.importJson(ls_json)

I'm on 2019 R2 Build 2170

Ideas?

 

Originally in code I was creating a local datawindow to test this.  When I changed it to a local datastore it worked as expected.

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 23 March 2021 19:32 PM UTC
  2. PowerBuilder
  3. # 1

Hi Mathew;

  FWIW: At a quick look it seems that columns like CaseID and CenterID and PatientID are numeric yet your DWO columns are all Char/VarChar.

  My suggestion also is to enter some test data in the Data Pane of the External DW Painter & then use the DC.ExportJSON() command in a test case App to save the DWO primary buffer as a JSON file format. Then compare the JSON formatting from the DWO export to the data & types used in your input file for the ImportJSON() command.

Regards ... Chris

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.