VBDS APIs are erroring out with 500 status code

[shuhood]

I have tried the Transaction Data API from Postman, but getting 500 status code. Although /helloworld API is working fine.
Request:
Url :https://sandbox.api.visa.com/cdsapi/commercial/v1/ob/trxndata

POST payload:

{
    "issuer": {
        "metadata": {
            "startDate": "2021/03/01",
            "endDate": "2021/03/20",
            "startIndex": 0
        },
        "bank": [
            {
                "regionId": 1,
                "processorId": 1,
                "bankId": "999999",
                "company": [
                    {
                        "companyId": "12345"
                    }
                ]
            }
        ]
    }
}

Response :
500 Internal Server Error
Time:1401 ms
Response body:

<?xml version='1.0' ?>
<env:Envelope xmlns:env='http://schemas.xmlsoap.org/soap/envelope/'>
    <env:Body>
        <env:Fault>
            <faultcode>env:Client</faultcode>
            <faultstring>Internal Error</faultstring>
        </env:Fault>
    </env:Body>
</env:Envelope>

Response Header:

[
    {
        "key": "X-SERVED-BY",
        "value": "l73c018" 
    },
    {
        "key": "X-CORRELATION-ID",
        "value": "1624441952_933_886683606_l73c018_VDP_WS" 
    },
    {
        "key": "X-Backside-Transport",
        "value": "FAIL FAIL,FAIL FAIL" 
    },
    {
        "key": "X-Global-Transaction-ID",
        "value": "1adcbd1660d3046138de8357" 
    }
]

I would appreciate any help troubleshooting this.
Thanks

[SLi]

Hi @shuhood,

We are taking a look at this issue and will get back with an update as soon as we can. Thanks for your patience.

[SLi]

Hi @shuhood,

Thank you for your patience. I'm happy to share that the issue has been fixed. Please try to use the VBDS API again and let us know if it still doesn't work.

[shuhood]

Thanks Stacey for the update.
Now the request is being processed - getting a 200 status code. But for the same POST payload given above, we are getting an empty response.
Request:
Url: https://sandbox.api.visa.com/cdsapi/commercial/v1/ob/trxndata

body:

{
    "issuer": {
        "metadata": {
            "startDate": "2018/06/17",
            "endDate": "2018/07/16",
            "startIndex": 0
        },
        "bank": [
            {
                "regionId": 1,
                "processorId": 1,
                "bankId": "999999",
                "company": [
                    {
                        "companyId": "12345"
                    }
                ]
            }
        ]
    }
}

Response:

{
    "transactionData": {
        "responseMetadata": {
            "requestId": "1624590578_876_254620990_l73c018_VDP_WS"
        },
        "starterInfo": {}
    }
}

X-CORRELATION-ID : 1624590578_876_254620990_l73c018_VDP_WS

Can you please guide us what should be the request body for VBDS Transaction Data API (/trxndata) to play around with test/mock data using sandbox API. Also we would like to know the request payload for VBDS Authorization Data API(/authdata) too.

Any way what was the root cause for the earlier issue, did we miss anything from our side?

Thanks

[SLi]

Hi @shuhood,

Please try below test payload for Transaction Data API, you should get 10 records back.

{"issuer": {
"metadata": {
"startIndex": 0,
"endDate": "2021/03/20",
"startDate": "2021/03/01"
},
"bank": [{
"bankId": "999999",
"processorId": 1,
"regionId": 1,
"company": [{"companyId": "12345"}]
}]
}}

The earlier issue was caused by an expired certificate on Visa side and has been fixed. I will get back to you on a working test payload for Auth Data API. 

[shuhood]

Hi,
I tried the trxndata API with the provided payload, still the response is empty.

{
    "transactionData": {
        "responseMetadata": {
            "requestId": "1624592894_216_1383305177_l73c013_VDP_WS"
        },
        "starterInfo": {}
    }
}

 
Thanks

[SLi]

Hi @shuhood,

Please share x-correlation id from the response header so we may look up the issue. Thanks.

[shuhood]

Hi,
I think its same as the requestId in the response body.
"key":"X-CORRELATION-ID","value":"1624593063_333_1098869938_l73c015_VDP_WS"

Thanks.

[SLi]

Hi @shuhood,

For authdata, please try below test payload in sandbox.

{

    "authIssuerReq": {

        "metadata": {

            "startDate": "20210601",

            "endDate": "20210625",

            "fetchAll": "true"

        },

        "bankList": [

            {

                "regionId": "1",

                "processorId": "1",

                "bankId": "999999",

                "companyList": [

                    {

                        "companyId": "789452",

                        "acctList": [

                            "all"

                        ]

                    }

                ]

            }

        ]

    },

    "authDataFields": "all"

}

[shuhood]

Hi,
The authdata API POST request with the above payload returns 500 status response. Also it took more than 2 mins to get the response.
{"key":"X-CORRELATION-ID","value":"1624679236_470_1767098294_l73c016_VDP_WS"}

URL: https://sandbox.api.visa.com/cdsapi/commercial/v1/ob/authdata
Method: POST
Request:
  Header:
     Accept:application/json
  Body:
  {
    "authIssuerReq": {
        "metadata": {
            "startDate": "20210601",
            "endDate": "20210625",
            "fetchAll": "true"
        },
        "bankList": [
            {
                "regionId": "1",
                "processorId": "1",
                "bankId": "999999",
                "companyList": [
                    {
                        "companyId": "789452",
                        "acctList": [
                            "all"
                        ]
                    }
                ]
            }
        ]
    },
    "authDataFields": "all"
  }
------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------
Response:
  Status: 500 Internal Server Error
  Response Time ~ 2 min 0.90 s
  Header : {"key":"X-CORRELATION-ID","value":"1624679236_470_1767098294_l73c016_VDP_WS"}
  Body:

  <?xml version='1.0' ?>
  <env:Envelope xmlns:env='http://schemas.xmlsoap.org/soap/envelope/'>
    <env:Body>
        <env:Fault>
            <faultcode>env:Client</faultcode>
            <faultstring>Internal Error</faultstring>
        </env:Fault>
    </env:Body>
  </env:Envelope>

 
Thanks