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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.