VBDS APIs are erroring out with 500 status code

Solved! Go to solution
shuhood
Helper

VBDS APIs are erroring out with 500 status code

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

16 REPLIES 16
SLi
Visa Developer Support Specialist
Visa Developer Support Specialist

Re: VBDS APIs are erroring out with 500 status code

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.


Best,
Stacey

Was your question answered? Don't forget to click on "Accept as Solution" to help other devs find the answer to the same question.
SLi
Visa Developer Support Specialist
Visa Developer Support Specialist

Re: VBDS APIs are erroring out with 500 status code

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.


Best,
Stacey

Was your question answered? Don't forget to click on "Accept as Solution" to help other devs find the answer to the same question.
shuhood
Helper

Re: VBDS APIs are erroring out with 500 status code

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
Visa Developer Support Specialist
Visa Developer Support Specialist

Re: VBDS APIs are erroring out with 500 status code

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. 


Best,
Stacey

Was your question answered? Don't forget to click on "Accept as Solution" to help other devs find the answer to the same question.
shuhood
Helper

Re: VBDS APIs are erroring out with 500 status code

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
Visa Developer Support Specialist
Visa Developer Support Specialist

Re: VBDS APIs are erroring out with 500 status code

Hi @shuhood,

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


Best,
Stacey

Was your question answered? Don't forget to click on "Accept as Solution" to help other devs find the answer to the same question.
shuhood
Helper

Re: VBDS APIs are erroring out with 500 status code

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
Visa Developer Support Specialist
Visa Developer Support Specialist

Re: VBDS APIs are erroring out with 500 status code

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"

}


Best,
Stacey

Was your question answered? Don't forget to click on "Accept as Solution" to help other devs find the answer to the same question.
shuhood
Helper

Re: VBDS APIs are erroring out with 500 status code

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