Help us improve your experience.

Let us know what you think.

Do you have time for a two-minute survey?

 
 

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