Sandbox merchant search API request is failing

[rlandge]

I have created a sandbox environment in local and I was able to call the merchant search API till yesterday.

However I tried calling the API since morning and I am getting a 500 internal error.The API was working yesterday,

Please find request details below.

Endpoint:https://sandbox.api.visa.com/merchantsearch/v1/search

Request body :

{

"searchOptions": {

"matchScore": "true",

"matchIndicators": "true"

},

"header": {

"requestMessageId": "VCO_GMR_001",

"messageDateTime": "2015-08-28T22:05:00.000"

},

"searchAttrList": {

"merchantCountryCode": 840,

"merchantName": "starbucks"

},

"responseAttrList": [

"GNLOCATOR"

]

}

Please let me know how to fix this issue

[jenn_kh]

Thank you for reaching out, @rlandge! An agent will get back to you as soon as possible. Until then, if any community members know a solution, feel free to reply here.

[API_Products · Accepted solution]

Hi @rlandge,

It could have been an intermittent outage. I ran a sandbox test today and received a successful request/response payload in sandbox. You can see my sample request/response payload below.

End Point https://sandbox.api.visa.com/merchantsearch/v2/search
Method POST
Request
{
"searchOptions": {
"matchScore": "true",
"maxRecords": "10",
"matchIndicators": "true",
"proximity": ["merchantName"],
"wildCard": ["merchantName"]
},
"header": {
"startIndex": "0",
"requestMessageId": "Request_001",
"messageDateTime": "2021-07-16T18:05:51.000"
},
"searchAttrList": {
"merchantPhoneNumber": "19897747123",
"merchantCity": "Mount Pleasant",
"merchantCountryCode": "840",
"paymentAcceptanceMethod": "F2F",
"acquiringBin": "476197",
"merchantState": "MI",
"acquirerCardAcceptorId": "424295031886",
"merchantName": "cmu edctn materials cntr",
"terminalType": "SWIPE",
"merchantPostalCode": "48858",
"visaStoreId": "161688518",
"businessRegistrationId": "386004447",
"merchantStreetAddress": "802 industrial dr",
"merchantUrl": "http://www.emc.cmich.edu/"
},
"responseAttrList": ["GNSTANDARD"]
}
Response
{"merchantSearchServiceResponse": {
"response": [{
"matchScore": 17.735136,
"matchIndicators": {
"merchantPhoneNumber": "N",
"merchantCountryCode": "Y",
"merchantCity": "N",
"merchantPostalCode": "N",
"visaStoreId": "Y",
"businessRegistrationId": "N",
"acquiringBin": "N",
"merchantStreetAddress": "N",
"merchantState": "N",
"acquirerCardAcceptorId": "N",
"merchantUrl": "N",
"merchantName": "N"
},
"responseValues": {
"visaEnterpriseName": "STARBUCKS CORPORATION",
"merchantPhoneNumber": [{
"number": "4153440351",
"type": "O"
}],
"merchantCountryCode": "840",
"visaEnterpriseId": "336582810",
"locationAddressLongitude": "-122.393581",
"paymentAcceptanceMethod": ["F2F"],
"merchantCategoryCodeDesc": ["FAST FOOD RESTAURANTS"],
"firstTranDateRange": "IN MORE THAN 365 DAYS",
"merchantState": "CA",
"visaStoreName": "STARBUCKS",
"locationAddressLatitude": "37.776827",
"merchantPostalCode": "94107-1702",
"visaStoreId": "161688518",
"dbaname": ["Starbucks Store 06677"],
"visaMerchantName": "STARBUCKS",
"soleProprietorIndicator": "N",
"lastTranDateRange": "IN LAST 90 DAYS",
"merchantCity": "SAN FRANCISCO",
"smallBusinessIndicator": "N",
"terminalType": [
"SWIPE",
"CHIP",
"PAYWAVE"
],
"visaMerchantId": "29992901",
"primaryMerchantCategoryCode": "5814",
"merchantCategoryCode": ["5814"],
"businessLegalName": ["Starbucks Corporation"],
"merchantStreetAddress": "280 KING ST",
"merchantUrl": ["www.starbucks.com"]
}
}],
"header": {
"numRecordsReturned": 1,
"startIndex": "0",
"numRecordsMatched": 1,
"responseMessageId": "816da1c1-4130-4580-987e-c91f2de329f9",
"endIndex": "0",
"requestMessageId": "Request_001",
"messageDateTime": "2023-08-28T22:30:21.021"
},
"status": {
"statusDescription": "Success",
"statusCode": "CDI000"
}
}}
Response Header
Status Code: 200
Server : nginx
Date : Mon, 28 Aug 2023 22:30:22 GMT
Content-Type : application/json
Content-Length : 1612
Connection : keep-alive
X-SERVED-BY : -5d47468k6
X-CORRELATION-ID : 1693261820_972_884090944_-5d47468k6_VDP_WS
response-message-id : 816da1c1-4130-4580-987e-c91f2de329f9
response-message-ts : 2023-08-28T22:30:21.972067858Z
X-AGS-Request-ID : v3:8653:sandbox:73c009:e5e7ea93061152f4537b00bf8beff470
X-AGS-Request-ID : v3:8653:sandbox:55c028:51b85bf27324279353b60dc749622797
X-APP-STATUS : 200
Cache-Control : no-cache, no-store, must-revalidate
X-Frame-Options : SAMEORIGIN
X-XSS-Protection : 0
X-Content-Type-Options : nosniff
Strict-Transport-Security : max-age=31536000;includeSubdomains
Pragma : no-cache
Expires : -1
Content-Security-Policy-Report-Only : default-src 'self' https://*.v.me https://*.visa.com;script-src 'self' 'unsafe-inline' 'unsafe-eval' https://*.visa.com https://*.v.me;img-src 'self' https://*.v.me https://*.visa.com https://*.unica.com https://ad.doubleclick.net;style-src 'self' 'unsafe-inline' https://*.visa.com;object-src https://*.v.me https://*.visa.com data:;report-uri /logging/logCSPReport;
X-Content-Security-Policy-Report-Only : default-src 'self' https://*.v.me https://*.visa.com;script-src 'self' 'unsafe-inline' 'unsafe-eval' https://*.visa.com https://*.v.me;img-src 'self' https://*.v.me https://*.visa.com https://*.unica.com https://ad.doubleclick.net;style-src 'self' 'unsafe-inline' https://*.visa.com;object-src https://*.v.me https://*.visa.com data:;report-uri /logging/logCSPReport;
X-WebKit-CSP-Report-Only : default-src 'self' https://*.v.me https://*.visa.com;script-src 'self' 'unsafe-inline' 'unsafe-eval' https://*.visa.com https://*.v.me;img-src 'self' https://*.v.me https://*.visa.com https://*.unica.com https://ad.doubleclick.net;style-src 'self' 'unsafe-inline' https://*.visa.com;object-src https://*.v.me https://*.visa.com data:;report-uri /logging/logCSPReport;
X-XSS-Protection : 1; mode=block
X-Content-Type-Options : nosniff
Strict-Transport-Security : max-age=31536000;includeSubdomains;always