APIPythonOpen-Source Solutions

Hi,

I am provisioning my Mssql dsource with the below API script:


"container": {
        "group": "GROUP-42",
        "name": "VD_20",
        "type": "MSSqlDatabaseContainer"
    },
    "recoveryModel": "SIMPLE",
    "source": {
        "type": "MSSqlVirtualSource",
        "allowAutoVDBRestartOnHostReboot": true
    },
    "sourceConfig": {
        "databaseName": "VD_20",
        "instance": {
            "host": "WINDOWS_HOST-26",
            "type": "MSSqlInstanceConfig"
        },
        "repository": "MSSQL_INSTANCE-2",
        "type": "MSSqlSIConfig"
    },
    "timeflowPointParameters": {
        "timeflow": "MSSQL-TIMEFLOW-1",
        "timestamp": "2018-02-19T04:31:39.000Z",
        "type": "MSSqlTimeflow"
        
  },
    "type": "MSSqlProvisionParameters"
}

after executing the code i am getting the below error:

{"type":"ErrorResult","status":"ERROR","error":{"type":"APIError","details":{"timeflowPointParameters":{"type":{"details":"Unexpected object type \"MSSqlTimeflow\". Expected \"TimeflowPointParameters\" or sub type.","action":null,"id":"exception.validation.object.type.unexpected","commandOutput":null,"diagnoses":null}}},"action":"Check your input parameters and try again.","id":"exception.validation.bad.input","commandOutput":null,"diagnoses":null}}

Regards,
Swathy

That section wants a Type of TimeFlowPointParameters. Look at http://<engine ip>/api/#TimeflowPointParameters for possible object types.

=== POST /resources/json/delphix/database/provision ===

{

    "type": "MSSqlProvisionParameters",

    "container": {

        "type": "MSSqlDatabaseContainer",

        "name": "MSSQLVDB",

        "group": "GROUP-35"

    },

    "source": {

        "type": "MSSqlVirtualSource",

        "allowAutoVDBRestartOnHostReboot": false

    },

    "sourceConfig": {

        "type": "MSSqlSIConfig",

        "repository": "MSSQL_INSTANCE-1",

        "databaseName": "MSSQLVDB"

    },

    "timeflowPointParameters": {

        "type": "TimeflowPointSemantic",

        "container": "MSSQL_DB_CONTAINER-1"

    }

}

Hi,

This is related to API parameters that aren't correct as per the documentation you have to use the following :

timeflowPointParameters:
        type: TimeflowPointTimestamp (*)
        timeflow: (required)
        timestamp: (required)

You have to change the value the parameter in bold on your code no "MSSqlTimeflow" in the API

Regards,

Mouhssine

Hi, I would recommend provisioning via the cli first. Then destroy and provision again, this time with tracing on to see the corresponding json. You turn tracing on in the cli with the following command: setopt trace=true.

I demonstrate that in this video:

https://vimeo.com/170187276 

Thanks Adam and Mouhssine.

I have changed the property in the code as :

"timeflowPointParameters": {
        "type": "TimeflowPointSemantic",

        "container": "MSSQL_DB_CONTAINER-254"
        
  },

Regards,
Swathy