Insert Bulk Data to Lookup Table

post/lookuptablemanager.loaddata/{TypeCode}

Inserts multiple records to the specified Lookup Table.

The /loaddata operation is a very efficient and quick way to insert bulk data. The main advantage is its greater speed when loading thousands of records (compared to e.g. /integrate).

Securitybasic or X-PriceFx-jwt
Request
path Parameters
TypeCode
required
string

Enter the type code of the Lookup Table entity you want to insert a data to.

Possible values: "JLTV" "JLTVM" "LT" "LTT" "LTV" "MLTV" "MLTV2" "MLTV3" "MLTV4" "MLTV5" "MLTV6" "MLTVM"
Example: MLTV
Request Body schema: application/json

We used /lookuptablemanager.loaddata/MLTV in the request example to insert bulk data to Matrix Lookup Table. Notice that the lookupTable is used in the header section and then ID of the Lookup Table in the data section

required
object
header
required
Array of any

Specify fields (columns) where you want to insert the data to.

data
required
Array of any

Enter values you want to add to the fields (columns).

Responses
200

OK

Response Schema: application/json
required
object
node
required
string non-empty
csrfToken
required
string non-empty
data
required
Array of objects
status
required
number
Request samples
application/json
{
  • "data": {
    • "header": [
      • "attribute1",
      • "lookupTable"
      ],
    • "data": [
      • [
        • "att1-1",
        • "2147484051"
        ],
      • [
        • "att1-2",
        • "2147484051"
        ],
      • [
        • "att1-3",
        • "2147484051"
        ]
      ]
    }
}
Response samples
application/json
{
  • "response": {
    • "node": "string",
    • "csrfToken": "string",
    • "data": [
      • { }
      ],
    • "status": 0
    }
}