Hi,
When exporting a job with the API, I can see in the JSON response the list of the components in that job, and for each component, the list of its fields, but I cannot find the type of the component.
To explain better with an example:
A "Table Input" component is made of the following fields (on Matillion for Redshift):
- Name
- Schema
- Table Name
- Column Names
- Trim Columns
... and those fields appear in the JSON response, but there is no information telling that the component is a "Table Input".
I could check all the fields and deduce it is a Table Input, but this would be a quite risky way to proceed.
Is there another way or is that information simply missing in the response?
Thanks for any help!
Cyrille Dakhlia
Here is an extract of a transformation export:
{
"objects": [
{
"jobObject": {
"JobType": ".TransformationJob",
"id": 282,
"revision": 2,
"created": 1631711226750,
"timestamp": 1631711226750,
"components": {
"288": {
"id": 288,
"inputCardinality": "ZERO",
"outputCardinality": "MANY",
"implementationID": 1354890871,
"x": 892,
"y": 256,
"width": 32,
"height": 32,
"inputConnectorIDs": [],
"outputConnectorIDs": [
299
],
"parameters": {
"1": {
"slot": 1,
"name": "Name",
"elements": {
"1": {
"slot": 1,
"values": {
"1": {
"slot": 1,
"type": "STRING",
"value": "matillion_us_state_lookup"
}
}
}
},
"visible": true
},
"2": {
"slot": 2,
"name": "Table Name",
"elements": {
"1": {
"slot": 1,
"values": {
"1": {
"slot": 1,
"type": "STRING",
"value": "matillion_us_state_lookup"
}
}
}
},
"visible": true
},
"3": {
"slot": 3,
"name": "Column Names",
"elements": {
"1": {
"slot": 1,
"values": {
"1": {
"slot": 1,
"type": "STRING",
"value": "name"
}
}
},
"2": {
"slot": 2,
"values": {
"1": {
"slot": 1,
"type": "STRING",
"value": "code"
}
}
}
},
"visible": true
},
"4": {
"slot": 4,
"name": "Trim Columns",
"elements": {
"1": {
"slot": 1,
"values": {
"1": {
"slot": 1,
"type": "STRING",
"value": "No"
}
}
}
},
"visible": true
},
"5": {
"slot": 5,
"name": "Schema",
"elements": {
"1": {
"slot": 1,
"values": {
"1": {
"slot": 1,
"type": "STRING",
"value": "[Environment Default]"
}
}
}
},
"visible": true
}
},
"exportMappings": {},
"activationStatus": "ENABLED"
},