JSON to fields tutorial

Replace the JSON in the API Request editor with the following JSON:

{
    "api": "hub",
    "action": "createTransform",
    "authToken": "AuthorizedToken",
    "params": {
        "transformName": "TestTransform2",
        "transformActions": [
            {
                "inputFields": [
                    "In1"
                ],
                "outputFields": [
                    "Out1",
                    "Out2"
                ],
                "transformActionName": "jsonToTableFields",
                "transformParams": {
                    "mapOfPropertiesToFields": [
                        {
                            "propertyPath": "out1",
                            "name": "out1",
                            "type": "VARCHAR",
                            "length": 200
                        },
                        {
                            "propertyPath": "out2",
                            "name": "out2",
                            "type": "DOUBLE"
                        }
                ]
                }
            }
        ]
    }
}

Click Apply defaults to JSON request () to replace the "authToken" with a valid token from your session.

Click Send request ().

Observe the response and ensure the action completed successfully.

Replace the "params" property values with the following "params" values:

{
    "api": "hub",
    "action": "createIntegrationTable",
    "authToken": "AuthorizedToken",
    "params": {
        "databaseName": "faircom",
        "tableName": "test2",
        "fields": [
            {
                "name": "In1",
                "type": "JSON",
                "length": 100
            }
        ],
        "transformName": "TestTransform2"
    },
    "requestId": "00000006"
}

Click Apply defaults to JSON request () to replace the "authToken" with a valid token from your session.

Click Send request ().

Observe the response and ensure the action completed successfully.

Replace the JSON in the API Request editor with the following JSON:

{
    "api": "db",
    "action": "insertRecords",
     "authToken": "AuthorizedToken",
    "params": {
        "tableName": "test2",
        "dataFormat": "arrays",
        "databaseName": "faircom",
        "fieldNames": [
            "In1"
        ],
        "sourceData": [
            [
                {
                    "out1": "Text data 1.",
                    "out2": 1
                }],
                [{
                    "out1": "Text data 2.",
                    "out2": 2
                }
            ]
        ]
    }
}

Click Apply defaults to JSON request () to replace the "authToken" with a valid token from your session.

Click Send request ().

Observe the response and ensure the action completed successfully.

In the API Explorer navigation window, navigate to faircom>admin>Tables and select test2.

Click the Table Records tab.

Observe the out1 and out2 data that was transformed when the JSON object was added in Add records to the integration table