API Sandbox Network Error

Extensibility
1

Hi

I’m in the Sandbox Test Utility calling the endpoint https://api.quickfile.co.uk/1_2/Client/Create

When I click the Submit Json button I get this response:

{
  "Errors": {
    "Error": [
      "Internal Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)"
    ]
  }
}

I also tried the endpoint https://api.quickfile.co.uk/1_2/Client/Get with the same result.

When I changed to XML I got this response:

Cannot find client (106476)

2

I’m getting the same error:

https://api.quickfile.co.uk/d/v1_2/Invoice_Search

Request:

{
  "payload": {
    "Header": {
      "@xmlns": "https://api.quickfile.co.uk",
      "MessageType": "Request",
      "SubmissionNumber": "x",
      "Authentication": {
        "AccNumber": "x",
        "MD5Value": "x",
        "ApplicationID": "x"
      }
    },
    "Body": {
      "@xmlns": "https://api.quickfile.co.uk",
      "SearchParameters": {
        "ReturnCount": "10",
        "Offset": "0",
        "OrderResultsBy": "InvoiceNumber",
        "OrderDirection": "ASC",
        "InvoiceType": "INVOICE",
        "ShowDeleted": "false",
        "ClientDetails": {
          "ClientID": "x"
        }
      }
    }
  }
}

Response:

{
  "Errors": {
    "Error": [
      "Internal Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)"
    ]
  }
}
3

Morning @Dean, @ArcScisl

Apologies for this. Our team did identify an issue and have resolved this. Would you mind rechecking please and letting me know if this works ok?

4

This is working now, thanks for the quick fix.

1 Like
5

Yes, working now thank you

1 Like