Portfolios

{
    "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"
        },
    ],
}