{
"title": "{job_prefix} [{profile_name} {profile_id}]: Portfolios",
"type": "io",
"input": {
"use": "amazon_advertising.io#AmazonAdvertisingInput",
"profile_id": "{profile_id}",
"endpoints": {
"get": "/portfolios",
},
"credentials": null,
},
"output": {
"use": "call:mitto.iov2.db#todb",
"dbo": "postgres://localhost/analytics",
"schema": "{job_prefix}_{safe__profile_name}_{profile_id}",
"tablename": "portfolios"
},
"store": {
"key": ["$.profileId", "$.portfolioId"],
},
"steps": [
{
"use": "mitto.iov2.steps#Input",
"transforms": [
{
"use": "mitto.iov2.transform#PluckV2Transform",
"jpath": "$.[*]"
},
{
"use": "mitto.iov2.transform#ExtraColumnsTransform"
},
{
"use": "mitto.iov2.transform#ColumnsTransform"
}
],
},
{
"use": "mitto.iov2.steps#CreateTable"
},
{
"use": "mitto.iov2.steps#Output",
"transforms": [
{
"use": "mitto.iov2.transform#FlattenTransform"
}
],
},
{
"use": "mitto.iov2.steps#CollectMeta"
},
],
}