Added to the 20192021-0706-18 28 release is the support for two additional media types: CSV and Excel. Users may request top-level foundational standards exports in either CSV or Excel Workbook formatODM-XML, as a beta functionality. The media type for CSV ODM-XML is text/csv, while application/vnd.ms-excel for Excel.application/odm+xml. For CDASHIG, users will receive an ODM v1.3.2 document as the response payload. For ADaMIG, SDTMIG, and SENDIG, user will receive a Define-XML v2.1 document. Note |
---|
ODM-XML, | Note |
---|
CSV and Excel Workbook media types are only available at the top-level of a foundational standard. When requesting them at levels in any lower hierarchy, the API will return an HTTP 406 Not Acceptable status code. |
Info |
---|
Refer to Limitations for an important note about the CSV and Excel exports. |
For example, a cURL snippet to obtain ADaM OCCDS v1.0 (lines #1-3), SDTMIG v3.3 (lines #5-7), and Controlled Terminology P38 (lines #9-11) in CSV formatODM format. The outputs are in Define-XML v2.1: Code Block |
---|
language | text |
---|
linenumbers | true |
---|
| curl -X GET \
https://library.cdisc.org/api/mdr/adam/adam-occds-1-0 \
-H 'Accept: textapplication/csvodm+xml'
curl -X GET \
https://library.cdisc.org/api/mdr/sdtmig/3-3 \
-H 'Accept: textapplication/csv'
odm+xml'
|
Another cURL snippet to obtain CDASHIG v2.1 in ODM format. The output is in ODM v1.3.2: Code Block |
---|
language | text |
---|
linenumbers | true |
---|
| curl -X GET \
https://library.cdisc.org/api/mdr/ctcdashig/packages/sdtmct-2019-06-282-1 \
-H 'Accept: textapplication/csvodm+xml'
| Similarly, Below is a cURL snippet to obtain ADaM OCCDS v1.0 (lines #1-3), SDTMIG v3.3 (lines #5-7), and Controlled Terminology P38 (lines #9-11) in Excel Workbook CSV format: Code Block |
---|
language | text |
---|
linenumbers | true |
---|
| curl -X GET \
https://library.cdisc.org/api/mdr/adam/adam-occds-1-0 \
-H 'Accept: application/vnd.ms-exceltext/csv'
curl -X GET \
https://library.cdisc.org/api/mdr/sdtmig/3-3 \
-H 'Accept: application/vnd.ms-excel'
text/csv'
curl -X GET \
https://library.cdisc.org/api/mdr/ct/packages/sdtmct-2019-06-28 \
-H 'Accept: application/vnd.ms-excel' |
|