API reference
API reference for the JSON to fields transform method
Abstract
API reference for the JSON to fields transform method
Request examples
Minimal request example
{ "api": "hub", "action": "createTransform", "authToken": "AuthorizedToken", "params": { "transformName": "TestTransform2", "transformActions": [ { "inputFields": [ "In1" ], "outputFields": [ "Out1" ], "transformActionName": "jsonPropertiesToTableFields", "transformParams": { "targetDatabaseName": "faircom", "targetTableName": "test_out2", "mapOfPropertiesToFields": [ { "propertyPath": "out1", "name": "out1", "type": "VARCHAR", "length": 200 } ] } } ] } }
{ "api": "hub", "apiVersion": "1.0", "requestId": "00000006", "action": "createTransform", "authToken": "AuthorizedToken", "params": { "transformName": "TestTransform2", "transformActions": [ { "inputFields": [ "In1" ], "outputFields": [ "Out1", "Out2" ], "transformActionName": "jsonPropertiesToTableFields", "transformParams": { "targetDatabaseName": "faircom", "targetTableName": "test_out2", "mapOfPropertiesToFields": [ { "propertyPath": "out1", "name": "out1", "type": "VARCHAR", "length": 200 }, { "propertyPath": "out2", "name": "out2", "type": "DOUBLE" } ] }, "metadata": { "myTag": "my data" } } ] }, "responseOptions": { "binaryFormat": "base64", "dataFormat": "arrays", "numberFormat": "number" } }
Response example
{ "authToken": "AuthorizedToken", "result": {}, "requestId": "00000007", "errorCode": 0, "errorMessage": "" }
"params"
The "params"
property is an object that contains an action's parameters. Each action defines its own required and optional properties.
Property summary
Table 1.
"params"
property summariesProperty | Description | Default | Type | Limits | ||
---|---|---|---|---|---|---|
specifies | Required - No default value | array of objects | ||||
| specifies the name of a transform process | Required - No default value | string |
|
The "transformActions"
property is an optional array of "transformAction"
objects. It defaults to an empty array.