GET breeze/Customers/QueryView?SqlWhereClause={SqlWhereClause}

No documentation available.

Request Information

Parameters

NameDescriptionAdditional information
SqlWhereClause
No documentation available.

Define this parameter in the request URI.

Response Information

Response body formats

application/json, text/json

Sample:
[
  {
    "CUSTTYPE": "sample string 1",
    "CUSTTYPENO": 2,
    "SYSID": "sample string 3",
    "NAME": "sample string 4",
    "CONTACT": "sample string 5",
    "ADDRESS1": "sample string 6",
    "ADDRESS2": "sample string 7",
    "ADDRESS3": "sample string 8",
    "CITY": "sample string 9",
    "STATE": "sample string 10",
    "ZIPCODE": "sample string 11",
    "COUNTRYID": "sample string 12",
    "PHONE": "sample string 13",
    "PHONE2": "sample string 14",
    "FAXNO": "sample string 15",
    "EMAIL": "sample string 16",
    "CONO": 1,
    "CUSTNO": 1,
    "VENDORID": "sample string 17",
    "COMMENTS": "sample string 18",
    "CORPNO": 1,
    "CORPFLAG": "sample string 19",
    "CURRENCYCD": "sample string 20",
    "PAYTERMS": "sample string 21",
    "TATCODE": "sample string 22",
    "TERRITORY": "sample string 23",
    "REGION": "sample string 24",
    "PRODUCTID": "sample string 25",
    "SERIALNO": "sample string 26",
    "UNIQSERIAL": "sample string 27",
    "DbFileName": "sample string 28",
    "DbForeignKeys": [
      "sample string 1",
      "sample string 2",
      "sample string 3"
    ]
  },
  {
    "CUSTTYPE": "sample string 1",
    "CUSTTYPENO": 2,
    "SYSID": "sample string 3",
    "NAME": "sample string 4",
    "CONTACT": "sample string 5",
    "ADDRESS1": "sample string 6",
    "ADDRESS2": "sample string 7",
    "ADDRESS3": "sample string 8",
    "CITY": "sample string 9",
    "STATE": "sample string 10",
    "ZIPCODE": "sample string 11",
    "COUNTRYID": "sample string 12",
    "PHONE": "sample string 13",
    "PHONE2": "sample string 14",
    "FAXNO": "sample string 15",
    "EMAIL": "sample string 16",
    "CONO": 1,
    "CUSTNO": 1,
    "VENDORID": "sample string 17",
    "COMMENTS": "sample string 18",
    "CORPNO": 1,
    "CORPFLAG": "sample string 19",
    "CURRENCYCD": "sample string 20",
    "PAYTERMS": "sample string 21",
    "TATCODE": "sample string 22",
    "TERRITORY": "sample string 23",
    "REGION": "sample string 24",
    "PRODUCTID": "sample string 25",
    "SERIALNO": "sample string 26",
    "UNIQSERIAL": "sample string 27",
    "DbFileName": "sample string 28",
    "DbForeignKeys": [
      "sample string 1",
      "sample string 2",
      "sample string 3"
    ]
  },
  {
    "CUSTTYPE": "sample string 1",
    "CUSTTYPENO": 2,
    "SYSID": "sample string 3",
    "NAME": "sample string 4",
    "CONTACT": "sample string 5",
    "ADDRESS1": "sample string 6",
    "ADDRESS2": "sample string 7",
    "ADDRESS3": "sample string 8",
    "CITY": "sample string 9",
    "STATE": "sample string 10",
    "ZIPCODE": "sample string 11",
    "COUNTRYID": "sample string 12",
    "PHONE": "sample string 13",
    "PHONE2": "sample string 14",
    "FAXNO": "sample string 15",
    "EMAIL": "sample string 16",
    "CONO": 1,
    "CUSTNO": 1,
    "VENDORID": "sample string 17",
    "COMMENTS": "sample string 18",
    "CORPNO": 1,
    "CORPFLAG": "sample string 19",
    "CURRENCYCD": "sample string 20",
    "PAYTERMS": "sample string 21",
    "TATCODE": "sample string 22",
    "TERRITORY": "sample string 23",
    "REGION": "sample string 24",
    "PRODUCTID": "sample string 25",
    "SERIALNO": "sample string 26",
    "UNIQSERIAL": "sample string 27",
    "DbFileName": "sample string 28",
    "DbForeignKeys": [
      "sample string 1",
      "sample string 2",
      "sample string 3"
    ]
  }
]

application/xml

Sample:

Sample not available.

text/xml

Sample:

Sample not available.