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.