Problem with pulling sales data data that I never had problems with pulling before as of Feb 1st

ScottMcCambleyScottMcCambley Member Posts: 1


Each month I gather our cash register sales from our students and create an itemized monthly sales receipt for our Parents. This month for some reason I can only pull data from the Sales table and not from any of the other tables I access such as Saleline. I get a "Bad Request" message returned. Has the structure or naming of these endpoints changed at all in the last month? Any ideas why I'm getting a bad request for something so simple.



OAuth Access Token

457f453f68b0c8e3bdd8f5e3d9e44facXXXXXX

———————————————————————————————————————————————————————————

Failed SalesLine URL Requet

API URL

https://api.merchantos.com/API/Account/9XXXX/SaleLine.xml?version=2&limit=100&offset=0&timeStamp=%3E%3C,2021-01-01T00:00%2D04:00,2021-01-31T23:59:59%2D04:00

Result

<?xml version="1.0"?>

<Error><httpCode>400</httpCode><httpMessage>Bad Request</httpMessage><message>findAllByFieldMatch got search for "version". Did you mean: Shop?</message><errorClass>Exception</errorClass></Error>



———————————————————————————————————————————————————————————

Successful Sales URL Request 

API URL

https://api.merchantos.com/API/Account/9XXXX/Sale.xml?offset=0&limit=100&timeStamp=%3E%3C,2021-01-01T00:00%2D04:00,2021-01-31T23:59:59%2D04:00&completed=true&voided=false

Result

<?xml version="1.0"?>

<Sales count="232" offset="0" limit="100"><Sale><saleID>276300</saleID><timeStamp>2021-01-05T15:08:40+00:00</timeStamp><discountPercent>0</discountPercent><completed>true</completed><archived>false</archived><voided>false</voided><enablePromotions>true</enablePromotions><isTaxInclusive>false</isTaxInclusive><createTime readonly="true">2021-01-05T15:08:19+00:00</createTime><updateTime readonly="true">2021-01-05T15:08:41+00:00</updateTime><completeTime>2021-01-05T15:08:40+00:00</completeTime><referenceNumber/><referenceNumberSource/><tax1Rate>0.05</tax1Rate><tax2Rate>0.08</tax2Rate><change currency="CAD">0</change><receiptPreference>printed</receiptPreference><displayableSubtotal ...........

Sign In or Register to comment.