sandbox transaction query giving error

[mhussain]

Hello,

I am trying to call https://sandbox.api.visa.com/visadirect/v1/transactionquery?acquiringBIN=408999 through my code as per the document here: https://developer.visa.com/capabilities/visa_direct/reference#visa_direct__query

I am keep getting following error:

{'errorMessage': "API Validation Error: 3001. Field '[acquiringBIN]' is invalid query parameter."}

My connectivity (helloworld) as well as other requests (pull/push/reverse funds) are working absolutely fine. Please let me know if I am missing something for transactionquery api call.

Best regards.

[API_Products]

Hi @mhussain,

Please review the Visa Direct documentation via this link - https://developer.visa.com/capabilities/visa_direct/docs 

In particular, see the top few paragraphs that are shaded in yellow that discuss the requirements to use Visa Direct.

After having read the documentation, if you meet those requirements, then please click through the link in those paragraphs to the Visa Direct Program Implementation Questionnaire, fill it out, and submit to the email address listed on that form. Please let us know if you have other questions.

[mhussain]

Hello Diana,

We are in development phase, while other sandbox endpoints like https://sandbox.api.visa.com/visadirect/fundstransfer/v1/pullfundstransactions are working fine with test acquiringBin, but https://sandbox.api.visa.com/visadirect/v1/transactionquery?acquiringBIN=408999 is not working. Is there any other specific requirement for transaction-query api endpoint we are missing and also please let us know if this endpoint is not available in sandbox environment.

Thank you.

[API_Products]

Hi  @mhussain,

Are you using Test Data? Please verify that you are using the data provided in the Test Data tables accessible on the left panel. Please navigate to the Visa Direct API project from your Dashboard and use the test data there.

[mhussain]

Hello Diana,

Thank you for getting back to us. Yes, we are using Test Data. 

When we are calling https://sandbox.api.visa.com/visadirect/v1/transactionquery without query parameter, we are getting following error:

400, API Validation Error: 3001. Mandatory field 'acquiringBIN' is missing or has invalid content.

When we are calling https://sandbox.api.visa.com/visadirect/v1/transactionquery?acquiringBIN=408999 with test data acquiring BIN, as required, we are getting following error:

400, API Validation Error: 3001. Field '[acquiringBIN]' is invalid query parameter.

Best regards.

[API_Products]

Hi @mhussain,

Thanks for your responses and for your patience. We are currently looking into your issue and someone will reach out to you shortly.

[mhussain]

Hello Diana,

Any update ?

[API_Products]

Hi @mhussain,

You will have to use either one of the below combinations to use our Query API. Below is the sample query call .

https://sandbox.api.visa.com/visadirect/v1/transactionquery?stan=235626&rrn=412770235626&acquiringBI...

or

https://sandbox.api.visa.com/visadirect/v1/transactionquery?acquiringBIN=408999&transactionIdentifie...

[mhussain]

Thank you Diana, it is working now 🙂

[fredg]

Hello,

When using those input parameters, we are getting:

https://sandbox.api.visa.com/visadirect/v1/transactionquery?acquiringBIN=408999&transactionIdentifie...

returns:

 "errorMessage": "No transactions found for the specified input parameters"

Can you please advise?