Skip to main content
Skip table of contents

Posting Tables

Sometimes it may be required to post multiple lines of table data in a single request. Special notation is required to support this scenario.

When a request body includes an array, universal iPaaS will check for special notation features referencing table data points. When referencing repeat items for table population, use the notation {t_TableName[FieldName]}

CODE
{
    "Line": [
        {
            "Amount": "{t_Expense Lines[Amount]}",
            "AccountBasedExpenseLineDetail": {
                "AccountRef": {
                    "value": "{t_Expense Lines[Category]}"
                }
            }
        }
    ]
}

In this example, “Line” is an array of objects. Using “t_” notation, Universal iPaaS knows to repeat the array element for each row of the referenced table.

DO NOT reference multiple tables in a single root element. This will not work and will cause error processes. You may have multiple root elements in an array that reference individual tables.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.