GET breeze/Products/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:
[
{
"PRODUCTID": "sample string 1",
"NAME": "sample string 2",
"MAKE": "sample string 3",
"MODEL": "sample string 4",
"PRODTYPE": "sample string 5",
"PARTCAT": "sample string 6",
"PRODCAT": "sample string 7",
"PWRNTYID": "sample string 8",
"RWRNTYID": "sample string 9",
"STDCOST": 1.1,
"WRNTYNO": 1,
"RWRNTYNO": 1,
"ACCTCLASS": "sample string 10",
"SITEID": "sample string 11",
"PRODUCTNO": "sample string 12",
"UOMCODE": "sample string 13",
"CONFIGPART": "sample string 14",
"REQCALIBR": "sample string 15",
"CALIBRPRD": 1.1,
"CALIBRUNT": "sample string 16",
"REQUIRERMA": "sample string 17",
"MFRNO": 1,
"CANREPAIR": "sample string 18",
"CANRETURN": "sample string 19",
"RTNSHOPID": "sample string 20",
"PRODPRDFLDs": [
{
"PRODUCTID": "sample string 1",
"SEQNO": 2,
"FIELDNO": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"SEQNO": 2,
"FIELDNO": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"SEQNO": 2,
"FIELDNO": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"PRODSAS": [
{
"PRODUCTID": "sample string 1",
"CGRPCODE": "sample string 2",
"WRNTYNO": 1,
"PWRNTYID": "sample string 3",
"RWRNTYID": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"CGRPCODE": "sample string 2",
"WRNTYNO": 1,
"PWRNTYID": "sample string 3",
"RWRNTYID": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"CGRPCODE": "sample string 2",
"WRNTYNO": 1,
"PWRNTYID": "sample string 3",
"RWRNTYID": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"PRODSRLFLDs": [
{
"PRODUCTID": "sample string 1",
"SERIALNO": "sample string 2",
"UNIQSERIAL": "sample string 3",
"FIELDNO": 4,
"THEVALUE": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"SERIALNO": "sample string 2",
"UNIQSERIAL": "sample string 3",
"FIELDNO": 4,
"THEVALUE": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"SERIALNO": "sample string 2",
"UNIQSERIAL": "sample string 3",
"FIELDNO": 4,
"THEVALUE": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"PRODCFGOPS": [
{
"PRODUCTID": "sample string 1",
"PRODCFGOPT": "sample string 2",
"DbFileName": "sample string 3",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"PRODCFGOPT": "sample string 2",
"DbFileName": "sample string 3",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"PRODCFGOPT": "sample string 2",
"DbFileName": "sample string 3",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"DbFileName": "sample string 21",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"NAME": "sample string 2",
"MAKE": "sample string 3",
"MODEL": "sample string 4",
"PRODTYPE": "sample string 5",
"PARTCAT": "sample string 6",
"PRODCAT": "sample string 7",
"PWRNTYID": "sample string 8",
"RWRNTYID": "sample string 9",
"STDCOST": 1.1,
"WRNTYNO": 1,
"RWRNTYNO": 1,
"ACCTCLASS": "sample string 10",
"SITEID": "sample string 11",
"PRODUCTNO": "sample string 12",
"UOMCODE": "sample string 13",
"CONFIGPART": "sample string 14",
"REQCALIBR": "sample string 15",
"CALIBRPRD": 1.1,
"CALIBRUNT": "sample string 16",
"REQUIRERMA": "sample string 17",
"MFRNO": 1,
"CANREPAIR": "sample string 18",
"CANRETURN": "sample string 19",
"RTNSHOPID": "sample string 20",
"PRODPRDFLDs": [
{
"PRODUCTID": "sample string 1",
"SEQNO": 2,
"FIELDNO": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"SEQNO": 2,
"FIELDNO": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"SEQNO": 2,
"FIELDNO": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"PRODSAS": [
{
"PRODUCTID": "sample string 1",
"CGRPCODE": "sample string 2",
"WRNTYNO": 1,
"PWRNTYID": "sample string 3",
"RWRNTYID": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"CGRPCODE": "sample string 2",
"WRNTYNO": 1,
"PWRNTYID": "sample string 3",
"RWRNTYID": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"CGRPCODE": "sample string 2",
"WRNTYNO": 1,
"PWRNTYID": "sample string 3",
"RWRNTYID": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"PRODSRLFLDs": [
{
"PRODUCTID": "sample string 1",
"SERIALNO": "sample string 2",
"UNIQSERIAL": "sample string 3",
"FIELDNO": 4,
"THEVALUE": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"SERIALNO": "sample string 2",
"UNIQSERIAL": "sample string 3",
"FIELDNO": 4,
"THEVALUE": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"SERIALNO": "sample string 2",
"UNIQSERIAL": "sample string 3",
"FIELDNO": 4,
"THEVALUE": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"PRODCFGOPS": [
{
"PRODUCTID": "sample string 1",
"PRODCFGOPT": "sample string 2",
"DbFileName": "sample string 3",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"PRODCFGOPT": "sample string 2",
"DbFileName": "sample string 3",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"PRODCFGOPT": "sample string 2",
"DbFileName": "sample string 3",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"DbFileName": "sample string 21",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"NAME": "sample string 2",
"MAKE": "sample string 3",
"MODEL": "sample string 4",
"PRODTYPE": "sample string 5",
"PARTCAT": "sample string 6",
"PRODCAT": "sample string 7",
"PWRNTYID": "sample string 8",
"RWRNTYID": "sample string 9",
"STDCOST": 1.1,
"WRNTYNO": 1,
"RWRNTYNO": 1,
"ACCTCLASS": "sample string 10",
"SITEID": "sample string 11",
"PRODUCTNO": "sample string 12",
"UOMCODE": "sample string 13",
"CONFIGPART": "sample string 14",
"REQCALIBR": "sample string 15",
"CALIBRPRD": 1.1,
"CALIBRUNT": "sample string 16",
"REQUIRERMA": "sample string 17",
"MFRNO": 1,
"CANREPAIR": "sample string 18",
"CANRETURN": "sample string 19",
"RTNSHOPID": "sample string 20",
"PRODPRDFLDs": [
{
"PRODUCTID": "sample string 1",
"SEQNO": 2,
"FIELDNO": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"SEQNO": 2,
"FIELDNO": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"SEQNO": 2,
"FIELDNO": 3,
"DbFileName": "sample string 4",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"PRODSAS": [
{
"PRODUCTID": "sample string 1",
"CGRPCODE": "sample string 2",
"WRNTYNO": 1,
"PWRNTYID": "sample string 3",
"RWRNTYID": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"CGRPCODE": "sample string 2",
"WRNTYNO": 1,
"PWRNTYID": "sample string 3",
"RWRNTYID": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"CGRPCODE": "sample string 2",
"WRNTYNO": 1,
"PWRNTYID": "sample string 3",
"RWRNTYID": "sample string 4",
"DbFileName": "sample string 5",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"PRODSRLFLDs": [
{
"PRODUCTID": "sample string 1",
"SERIALNO": "sample string 2",
"UNIQSERIAL": "sample string 3",
"FIELDNO": 4,
"THEVALUE": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"SERIALNO": "sample string 2",
"UNIQSERIAL": "sample string 3",
"FIELDNO": 4,
"THEVALUE": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"SERIALNO": "sample string 2",
"UNIQSERIAL": "sample string 3",
"FIELDNO": 4,
"THEVALUE": "sample string 5",
"DbFileName": "sample string 6",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"PRODCFGOPS": [
{
"PRODUCTID": "sample string 1",
"PRODCFGOPT": "sample string 2",
"DbFileName": "sample string 3",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"PRODCFGOPT": "sample string 2",
"DbFileName": "sample string 3",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
},
{
"PRODUCTID": "sample string 1",
"PRODCFGOPT": "sample string 2",
"DbFileName": "sample string 3",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
],
"DbFileName": "sample string 21",
"DbForeignKeys": [
"sample string 1",
"sample string 2",
"sample string 3"
]
}
]
application/xml
Sample:
Sample not available.
text/xml
Sample:
Sample not available.