Dump resource in CSV format
$dump-csv
operation dumps resource data in Aidbox format as CSV (RFC4180 ). In this format, columns are paths to JSON values and Rows are values. It includes the header.
Neither the specific order of columns nor the order of rows is guaranteed.
Request format
Copy GET [base]/<resourceType>/$dump-csv
Examples
Dump patients in CSV
Request Response
Rest Console
Copy GET / Patient / $dump - csv
Curl
Copy $ curl "$AIDBOX_BASE/\$dump-csv" \
-H 'authorization: Basic YnVsay1jbGllbnQ6c2VjcmV0'
Status
200 OK
Headers
Body
Copy citizenship.0.code.text,id,name.0.given.0,resourceType
,pt-1,Alice,Patient
,pt-2,Bob,Patient
ru,pt-3,Charles,Patient
Body as table
Dump Appointments in CSV
Request Response
REST Console
Copy GET /Appointment/$dump-csv
Curl
Copy curl -u bulk-client:secret $AIDBOX_BASE_URL /Patient/ \$ dump-csv
Status
200 OK
Headers
Body
Copy id,participant.0.actor.id,participant.0.actor.resourceType,participant.0.status,resourceType,status
ap-1,pt-1,Patient,accepted,Appointment,fulfilled
ap-2,pt-1,Patient,accepted,Appointment,booked
ap-3,pt-2,Patient,accepted,Appointment,fulfilled
Body as table
Last updated 2 months ago