Skip to main content

Fields to JSON tutorial

Tutorial to transform fields to JSON in the same table

The tutorials in this section show how to take new records that are added to an integration table, transform them into JSON, and store that JSON in a new field in the same table and record.

Requirements:

Tutorial for the table to JSON transform method

tutorialtable to JSONtransform methodJSON transformfields to JSON

Create a transform

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

    {
  "api": "transform",
  "authToken": "AuthorizedToken",
  "action": "createTransform",
  "params": {
    "transformName": "TestTransform1",
    "transformations": [
      {
        "inputFields": [
          "In1", "In2"
        ],
        "outputFields": [
          "Out1"
        ],
        "transformActionName": "tableFieldsToJson",
        "transformParams": {
          "mapOfFieldsToProperties": [
          {
            "propertyPath": "In1",
            "fieldName": "In1"
          },
          {
            "propertyPath": "In2",
            "fieldName": "In2"
          }
          ]
        }
      }
    ]
  }
}

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

  3. Click Send request (Runbutton.png).

  4. Observe the response and ensure the action completed successfully.

    Note

    "errorCode" with a value of 0 indicates success. "errorCode" with a non-zero value indicates a failure. See Errors and contact FairCom for more information about an error.

Create an integration table

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

    {
    "api": "hub",
    "authToken": "AuthorizedToken",
    "action": "createIntegrationTable",
    "params": {
        "databaseName": "faircom",
        "tableName": "test1",
        "fields": [
        {
            "name": "In1",
            "type": "VARCHAR",
            "length": 100
        },
        {
            "name": "In2",
            "type": "INTEGER"        },
        {
            "name": "Out1",
            "type": "VARCHAR",
            "length": 200
        }],
        "transformName": "TestTransform1"
    }
}

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

  3. Click Send request (Runbutton.png).

  4. Observe the response and ensure the action completed successfully.

    Note

    "errorCode" with a value of 0 indicates success. "errorCode" with a non-zero value indicates a failure. See Errors and contact FairCom for more information about an error.

Add records to the new integration table

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

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

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

  3. Click Send request (Runbutton.png).

  4. Observe the response and ensure the action completed successfully.

    Note

    "errorCode" with a value of 0 indicates success. "errorCode" with a non-zero value indicates a failure. See Errors and contact FairCom for more information about an error.

View the results in Table Records

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

  2. Click the Table Records tab.

  3. Observe the columns and data that the transform created and stored by using the horizontal scrollbar.

    Note

    The in1 and in2 fields show the inserted data fields. The out1 field shows the data from in1 and in2 but is transformed to JSON.