A Structured Data File (SDF) is a comma-separated values file used by
Display & Video 360 for bulk retrieval and management of resources. You can
download and upload SDFs through the Display & Video 360 UI. SDFs can
also be generated and downloaded using the Display & Video 360 API.
An SDF file is of a format specific to a version and Display & Video 360 resource
type.
There are two types of Structured Data Files formats offered by
Display & Video 360:
- Standard: This format can be used to retrieve and update Display & Video 360
resources.
- QA: This format can only be used to retrieve existing
Display & Video 360 resource settings. QA files provide the same information as
standard format files of the same version, but convey that information using
display name values instead of numeric IDs. Titles of columns changed in the
QA format are appended with "Qa".
The following rules apply to all Structured Data File formats:
- The first row of the file is always a header row containing the column names.
- Except for the first row, all non-missing string values are in quotation
marks.
- Missing values are left blank.
- For types marked as a list, expect the following:
- The list is a collection of strings.
- Each string is separated by a semicolon.
- A trailing semicolon follows the last string in the list.
- Example:
one;two;three;four;
- For types marked as a list of lists, expect the following:
- The list of lists is a collection of lists.
- Each sublist is enclosed by parentheses.
- Each sublist is separated from other sublists by a semicolon.
- A trailing semicolon follows the last list.
- Example:
(one;two;three;four;);(apples;bananas;);
Supported versions
The following versions and file types are currently supported:
v7.1
| Format and File type |
|
Standard
|
|
|
QA
|
|
v7
| Format and File type |
|
Standard
|
|
|
QA
|
|
v6
| Format and File type |
|
Standard
|
|
|
QA
|
|
