Tutorials

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.

Navigate to and select test_out2 in the Server navigation window through fair faircom>admin>Tables.

Click the Table Records tab.

Observe the out1 field's and out2 field's data that was extracted from the newly-added JSON object created in Create a transform.