GET api/Consumers/GetAllWhere?SqlWhereClause={SqlWhereClause}
No documentation available.
Request Information
Parameters
| Name | Description | Additional information |
|---|---|---|
| SqlWhereClause | No documentation available. |
Define this parameter in the request URI. |
Response Information
Response body formats
application/json, text/json
Sample:
[
{
"CONSUMERNO": 1,
"SYSID": "sample string 2",
"NAME": "sample string 3",
"CONTACT": "sample string 4",
"ADDRESS1": "sample string 5",
"ADDRESS2": "sample string 6",
"ADDRESS3": "sample string 7",
"CITY": "sample string 8",
"STATE": "sample string 9",
"ZIPCODE": "sample string 10",
"COUNTRYID": "sample string 11",
"PHONE": "sample string 12",
"PHONE2": "sample string 13",
"FAXNO": "sample string 14",
"EMAIL": "sample string 15",
"CONO": 1,
"CUSTNO": 1,
"VENDORID": "sample string 16",
"COMMENTS": "sample string 17",
"CORPNO": 1,
"CORPFLAG": "sample string 18",
"CARRIERID": "sample string 19",
"CARRACCTNO": "sample string 20",
"CURRENCYCD": "sample string 21",
"PAYTERMS": "sample string 22",
"TATCODE": "sample string 23",
"SHOPMTLMUL": 1.1,
"SHOPMTLCAP": 1.1,
"LABCHGRATE": 1.1,
"TERRITORY": "sample string 24",
"REGION": "sample string 25",
"REFNO": "sample string 26",
"SALESID": "sample string 27",
"MAINTYPE": "sample string 28",
"MAINTYPENO": 1,
"PREFTYPE": "sample string 29",
"PREFTYPENO": 1,
"CELLPHONE": "sample string 30",
"LOCID": "sample string 31",
"LEVELID": "sample string 32",
"BILLCORP": "sample string 33",
"DISPCORP": "sample string 34",
"ALIASNNAME": "sample string 35",
"CONSUMCONT": [
{
"CONSUMERNO": 1,
"SEQNO": 2,
"CONTACT": "sample string 3",
"TITLE": "sample string 4",
"ADD1": "sample string 5",
"ADD2": "sample string 6",
"ADD3": "sample string 7",
"ADD4": "sample string 8",
"ADD5": "sample string 9",
"CITY": "sample string 10",
"STATE": "sample string 11",
"ZIPCODE": "sample string 12",
"COUNTRYID": "sample string 13",
"PHONE1": "sample string 14",
"PHONE2": "sample string 15",
"CELL": "sample string 16",
"FAX": "sample string 17",
"EMAIL": "sample string 18",
"TIMESTMP": "2025-06-06T21:06:45.3819301+00:00",
"CONTTYPE": "sample string 19",
"GROUPID": "sample string 20",
"USERID": "sample string 21",
"REFNO": "sample string 22",
"DbFileName": "sample string 23",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"CONSUMERNO": 1,
"SEQNO": 2,
"CONTACT": "sample string 3",
"TITLE": "sample string 4",
"ADD1": "sample string 5",
"ADD2": "sample string 6",
"ADD3": "sample string 7",
"ADD4": "sample string 8",
"ADD5": "sample string 9",
"CITY": "sample string 10",
"STATE": "sample string 11",
"ZIPCODE": "sample string 12",
"COUNTRYID": "sample string 13",
"PHONE1": "sample string 14",
"PHONE2": "sample string 15",
"CELL": "sample string 16",
"FAX": "sample string 17",
"EMAIL": "sample string 18",
"TIMESTMP": "2025-06-06T21:06:45.3819301+00:00",
"CONTTYPE": "sample string 19",
"GROUPID": "sample string 20",
"USERID": "sample string 21",
"REFNO": "sample string 22",
"DbFileName": "sample string 23",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"CONSUMERNO": 1,
"SEQNO": 2,
"CONTACT": "sample string 3",
"TITLE": "sample string 4",
"ADD1": "sample string 5",
"ADD2": "sample string 6",
"ADD3": "sample string 7",
"ADD4": "sample string 8",
"ADD5": "sample string 9",
"CITY": "sample string 10",
"STATE": "sample string 11",
"ZIPCODE": "sample string 12",
"COUNTRYID": "sample string 13",
"PHONE1": "sample string 14",
"PHONE2": "sample string 15",
"CELL": "sample string 16",
"FAX": "sample string 17",
"EMAIL": "sample string 18",
"TIMESTMP": "2025-06-06T21:06:45.3819301+00:00",
"CONTTYPE": "sample string 19",
"GROUPID": "sample string 20",
"USERID": "sample string 21",
"REFNO": "sample string 22",
"DbFileName": "sample string 23",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"DbFileName": "sample string 36",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"CONSUMERNO": 1,
"SYSID": "sample string 2",
"NAME": "sample string 3",
"CONTACT": "sample string 4",
"ADDRESS1": "sample string 5",
"ADDRESS2": "sample string 6",
"ADDRESS3": "sample string 7",
"CITY": "sample string 8",
"STATE": "sample string 9",
"ZIPCODE": "sample string 10",
"COUNTRYID": "sample string 11",
"PHONE": "sample string 12",
"PHONE2": "sample string 13",
"FAXNO": "sample string 14",
"EMAIL": "sample string 15",
"CONO": 1,
"CUSTNO": 1,
"VENDORID": "sample string 16",
"COMMENTS": "sample string 17",
"CORPNO": 1,
"CORPFLAG": "sample string 18",
"CARRIERID": "sample string 19",
"CARRACCTNO": "sample string 20",
"CURRENCYCD": "sample string 21",
"PAYTERMS": "sample string 22",
"TATCODE": "sample string 23",
"SHOPMTLMUL": 1.1,
"SHOPMTLCAP": 1.1,
"LABCHGRATE": 1.1,
"TERRITORY": "sample string 24",
"REGION": "sample string 25",
"REFNO": "sample string 26",
"SALESID": "sample string 27",
"MAINTYPE": "sample string 28",
"MAINTYPENO": 1,
"PREFTYPE": "sample string 29",
"PREFTYPENO": 1,
"CELLPHONE": "sample string 30",
"LOCID": "sample string 31",
"LEVELID": "sample string 32",
"BILLCORP": "sample string 33",
"DISPCORP": "sample string 34",
"ALIASNNAME": "sample string 35",
"CONSUMCONT": [
{
"CONSUMERNO": 1,
"SEQNO": 2,
"CONTACT": "sample string 3",
"TITLE": "sample string 4",
"ADD1": "sample string 5",
"ADD2": "sample string 6",
"ADD3": "sample string 7",
"ADD4": "sample string 8",
"ADD5": "sample string 9",
"CITY": "sample string 10",
"STATE": "sample string 11",
"ZIPCODE": "sample string 12",
"COUNTRYID": "sample string 13",
"PHONE1": "sample string 14",
"PHONE2": "sample string 15",
"CELL": "sample string 16",
"FAX": "sample string 17",
"EMAIL": "sample string 18",
"TIMESTMP": "2025-06-06T21:06:45.3819301+00:00",
"CONTTYPE": "sample string 19",
"GROUPID": "sample string 20",
"USERID": "sample string 21",
"REFNO": "sample string 22",
"DbFileName": "sample string 23",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"CONSUMERNO": 1,
"SEQNO": 2,
"CONTACT": "sample string 3",
"TITLE": "sample string 4",
"ADD1": "sample string 5",
"ADD2": "sample string 6",
"ADD3": "sample string 7",
"ADD4": "sample string 8",
"ADD5": "sample string 9",
"CITY": "sample string 10",
"STATE": "sample string 11",
"ZIPCODE": "sample string 12",
"COUNTRYID": "sample string 13",
"PHONE1": "sample string 14",
"PHONE2": "sample string 15",
"CELL": "sample string 16",
"FAX": "sample string 17",
"EMAIL": "sample string 18",
"TIMESTMP": "2025-06-06T21:06:45.3819301+00:00",
"CONTTYPE": "sample string 19",
"GROUPID": "sample string 20",
"USERID": "sample string 21",
"REFNO": "sample string 22",
"DbFileName": "sample string 23",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"CONSUMERNO": 1,
"SEQNO": 2,
"CONTACT": "sample string 3",
"TITLE": "sample string 4",
"ADD1": "sample string 5",
"ADD2": "sample string 6",
"ADD3": "sample string 7",
"ADD4": "sample string 8",
"ADD5": "sample string 9",
"CITY": "sample string 10",
"STATE": "sample string 11",
"ZIPCODE": "sample string 12",
"COUNTRYID": "sample string 13",
"PHONE1": "sample string 14",
"PHONE2": "sample string 15",
"CELL": "sample string 16",
"FAX": "sample string 17",
"EMAIL": "sample string 18",
"TIMESTMP": "2025-06-06T21:06:45.3819301+00:00",
"CONTTYPE": "sample string 19",
"GROUPID": "sample string 20",
"USERID": "sample string 21",
"REFNO": "sample string 22",
"DbFileName": "sample string 23",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"DbFileName": "sample string 36",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"CONSUMERNO": 1,
"SYSID": "sample string 2",
"NAME": "sample string 3",
"CONTACT": "sample string 4",
"ADDRESS1": "sample string 5",
"ADDRESS2": "sample string 6",
"ADDRESS3": "sample string 7",
"CITY": "sample string 8",
"STATE": "sample string 9",
"ZIPCODE": "sample string 10",
"COUNTRYID": "sample string 11",
"PHONE": "sample string 12",
"PHONE2": "sample string 13",
"FAXNO": "sample string 14",
"EMAIL": "sample string 15",
"CONO": 1,
"CUSTNO": 1,
"VENDORID": "sample string 16",
"COMMENTS": "sample string 17",
"CORPNO": 1,
"CORPFLAG": "sample string 18",
"CARRIERID": "sample string 19",
"CARRACCTNO": "sample string 20",
"CURRENCYCD": "sample string 21",
"PAYTERMS": "sample string 22",
"TATCODE": "sample string 23",
"SHOPMTLMUL": 1.1,
"SHOPMTLCAP": 1.1,
"LABCHGRATE": 1.1,
"TERRITORY": "sample string 24",
"REGION": "sample string 25",
"REFNO": "sample string 26",
"SALESID": "sample string 27",
"MAINTYPE": "sample string 28",
"MAINTYPENO": 1,
"PREFTYPE": "sample string 29",
"PREFTYPENO": 1,
"CELLPHONE": "sample string 30",
"LOCID": "sample string 31",
"LEVELID": "sample string 32",
"BILLCORP": "sample string 33",
"DISPCORP": "sample string 34",
"ALIASNNAME": "sample string 35",
"CONSUMCONT": [
{
"CONSUMERNO": 1,
"SEQNO": 2,
"CONTACT": "sample string 3",
"TITLE": "sample string 4",
"ADD1": "sample string 5",
"ADD2": "sample string 6",
"ADD3": "sample string 7",
"ADD4": "sample string 8",
"ADD5": "sample string 9",
"CITY": "sample string 10",
"STATE": "sample string 11",
"ZIPCODE": "sample string 12",
"COUNTRYID": "sample string 13",
"PHONE1": "sample string 14",
"PHONE2": "sample string 15",
"CELL": "sample string 16",
"FAX": "sample string 17",
"EMAIL": "sample string 18",
"TIMESTMP": "2025-06-06T21:06:45.3819301+00:00",
"CONTTYPE": "sample string 19",
"GROUPID": "sample string 20",
"USERID": "sample string 21",
"REFNO": "sample string 22",
"DbFileName": "sample string 23",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"CONSUMERNO": 1,
"SEQNO": 2,
"CONTACT": "sample string 3",
"TITLE": "sample string 4",
"ADD1": "sample string 5",
"ADD2": "sample string 6",
"ADD3": "sample string 7",
"ADD4": "sample string 8",
"ADD5": "sample string 9",
"CITY": "sample string 10",
"STATE": "sample string 11",
"ZIPCODE": "sample string 12",
"COUNTRYID": "sample string 13",
"PHONE1": "sample string 14",
"PHONE2": "sample string 15",
"CELL": "sample string 16",
"FAX": "sample string 17",
"EMAIL": "sample string 18",
"TIMESTMP": "2025-06-06T21:06:45.3819301+00:00",
"CONTTYPE": "sample string 19",
"GROUPID": "sample string 20",
"USERID": "sample string 21",
"REFNO": "sample string 22",
"DbFileName": "sample string 23",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"CONSUMERNO": 1,
"SEQNO": 2,
"CONTACT": "sample string 3",
"TITLE": "sample string 4",
"ADD1": "sample string 5",
"ADD2": "sample string 6",
"ADD3": "sample string 7",
"ADD4": "sample string 8",
"ADD5": "sample string 9",
"CITY": "sample string 10",
"STATE": "sample string 11",
"ZIPCODE": "sample string 12",
"COUNTRYID": "sample string 13",
"PHONE1": "sample string 14",
"PHONE2": "sample string 15",
"CELL": "sample string 16",
"FAX": "sample string 17",
"EMAIL": "sample string 18",
"TIMESTMP": "2025-06-06T21:06:45.3819301+00:00",
"CONTTYPE": "sample string 19",
"GROUPID": "sample string 20",
"USERID": "sample string 21",
"REFNO": "sample string 22",
"DbFileName": "sample string 23",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"DbFileName": "sample string 36",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
]
application/xml
Sample:
Sample not available.
text/xml
Sample:
Sample not available.