Help us improve your experience.

Let us know what you think.

Do you have time for a two-minute survey?

ON THIS PAGE

Response Description
Response Sample

POST /reference_data/tables/bulk_load/{name}

SUMMARY Adds or updates data in a reference table.

Adds or updates data in a reference table.

Table 1: POST /reference_data/tables/bulk_load/{name} resource details:
POST /reference_data/tables/bulk_load/{name} resource details
MIME Type
application/json

Table 2: POST /reference_data/tables/bulk_load/{name} request parameter details:
POST /reference_data/tables/bulk_load/{name} request parameter details
Parameter	Type	Optionality	Data Type	MIME Type	Description
name	path	Required	String	text/plain	Required - The name of table to add or update data in.
fields	header	Optional	String	text/plain	Optional - Use this parameter to specify which fields you would like to get back in the response. Fields that are not named are excluded. Specify subfields in brackets and multiple fields in the same object are separated by commas.

Table 3: POST /reference_data/tables/bulk_load/{name} request body details:
POST /reference_data/tables/bulk_load/{name} request body details
Parameter	Data Type	MIME Type	Description	Sample
data	Array	application/json	Required - The JSON-formatted data to add or update in the reference table.	{"key1":{"col1":"Data11","col2":"Data12","col3":"Data13","col4":"Data14"}, "key2":{"col1":"Data21","col2":"Data22","col3":"Data23","col4":"Data24"}, "key3":{"col1":"Data31","col2":"Data32","col3":"Data33","col4":"Data34"}, "key4":{"col1":"Data41","col2":"Data42","col3":"Data43","col4":"Data44"}, "key5":{"col1":"Data51","col2":"Data52","col3":"Data53","col4":"Data54"}, "key6":{"col1":"Data61","col2":"Data62","col3":"Data63","col4":"Data64"}}

Table 4: POST /reference_data/tables/bulk_load/{name} response codes:
POST /reference_data/tables/bulk_load/{name} response codes
HTTP Response Code	Unique Code	Description
200		Data was successfully added or updated in the reference table.
400	1001	An error occurred parsing the JSON-formatted message body.
404	1002	The reference table does not exist.
422	1005	A request parameter is not valid.
500	1020	An error occurred during the attempt to add or update data in the reference table.

Response Description

Information about the reference table where data was added or updated. This returns information about the reference table but not the data that it contains.

Response Sample