Read Salesorder
Retrieves the details of a Salesorder object that has been previously created.
Parameters
Path Params | |
---|---|
yourCompany: | string |
Query Params | |
---|---|
filter: | string
List of condition abbrevations to be used: |
customview: | string https://xyzcompany.agiliron.net/agiliron/api-40/SalesOrder?customview=Paid Customview&key=xyzkey |
page: | int https://xyzcompany.agiliron.net/agiliron/api-40/SalesOrder?filter=Status,eq,Created | Invoiced | Shipped;Test CheckBox,eq,0&page=10&key=xyzkey |
pageSize: | int https://xyzcompany.agiliron.net/agiliron/api-40/SalesOrder?filter=Status,eq,Created | Invoiced | Shipped;Test CheckBox,eq,0&pageSize=10&key=xyzkey |
Header Params | |
---|---|
Accept: | string |
Query Auth | |
---|---|
key: | string |
Header Auth | |
---|---|
apiKey: | string |
Sample Code
NOTE: For SalesOrder ,
- OrdersId field contains Salesorderid.
- OrderNo field contains channel order id.
- AgilironOrderNo field contains order no.
{
"Orders": {
"Order": [
{
"OrderNo": 5531,
"AgilironOrderNo": 2224,
"SalesOrderId": 12224,
"ChannelId": 2563,
"ChannelName": "Amazon",
"OrderDate": "01-24-2020 07:08:13",
"OrderDateUTC": "01-24-2020 15:01:35",
"ModifiedDate": "01-24-2020 07:08:13",
"ModifiedTimeUTC": "01-24-2020 15:05:56",
"Subject": "Test New SalesOrder",
"PotentialName": "New Potential",
"QuoteName": "15march",
"AccountId": 156961,
"AccountName": "Test Account",
"AccountPhone": 2344452,
"AccountEmailAddress": "[email protected]",
"ContactId": 156962,
"ContactFirstName": "Contact Firstname",
"ContactLastName": "Contact Lastname",
"ContactPhone": 56984663,
"ContactEmailAddress": "[email protected]",
"BillingName": "Contact Firstname Contact Lastname",
"BillingStreet": "45623 Clean Drive",
"BillingCity": "Oakland",
"BillingState": "CA",
"BillingZipCode": 94601,
"BillingCountry": "UnitedStates",
"ShipToName": "Jane Doe",
"ShipToPhone": "(415)675-3134",
"ShipToEmailAddress": "[email protected]",
"ShippingStreet": "4567DoeCircle",
"ShippingCity": "SanFrancisco",
"ShippingState": "CA",
"ShippingZipCode": 94104,
"ShippingCountry": "UnitedStates",
"OrderDiscount": 5.55,
"OrderDiscountCode": "",
"SubTotal": 270.43,
"ShippingCost": 6.75,
"SalesTaxAuthority": "",
"SalesTaxes": 24.25,
"GrandTotal": 301.43,
"DefaultCurrency": "",
"ExchangeRate": "",
"Status": "Created,Paid,",
"ShippingStatus": "Ready to Pick,",
"AdditionalFees": 3.45,
"DefaultPriceBook": "Default",
"PaymentLineItems": {
"Payment": [
{
"PaymentMethod": "Cash",
"PaymentAmount": 9,
"PaymentDate": "2021-01-19",
"AmountDue": "6"
},
{
"PaymentMethod": "Check",
"PaymentAmount": 11,
"PaymentDate": "2021-01-20",
"CheckNumber": "",
"CheckWriter": "Test",
"AmountDue": "6"
}
]
},
"DueDate": "01-24-2020",
"InvoiceNo": "1881",
"InvoiceDate": "07-08-2021",
"CallDate": "01-24-2020",
"CustomerNo": 23276,
"AssignedTo": "admin",
"ExportToQuickbooks": 2,
"Type": "ASAP",
"Priority": "Standard",
"Pending": "Nothing",
"Salescommission": 30.14,
"TermsAndConditions": "Prepaid",
"Description": "Order notes goes here.",
"Carrier": "USPS",
"ShippingMethod": "Priority Mail 2-Day",
"DeliverFrom": "OAK",
"ShippingDate": "",
"TrackingNo": "",
"ActualShippingCost": 23,
"SpecialHandling": "Special Instructions goes here.",
"ShipQPriority": "Standard",
"BackorderHandling": "ShipAsAvailable",
"PacklistType": "Show Company Details and Logo",
"AmazonPrimeShipping": "Yes",
"Cancelled": "No",
"OnHold": "No",
"RelatedPOs": "",
"RelatedDropShipPOs": "",
"OrdersCustomFields": {
"CustomField": [
{
"Name": "CustomFied1",
"Value": "Custom info 1"
},
{
"Name": "CustomFied2",
"Value": "Custom info 2"
}
]
},
"OrderDetails": {
"OD": [
{
"OrderLineNo": "0",
"ProductsName": "Test New Product1",
"ProductCode": "TNP1",
"MatrixSKUCode": 0,
"SerialNo": "",
"ProductNotes": "Product notes goes here.",
"ProductsQuantityShipped": "0",
"ProductsQuantitySentToShipstation": "0",
"ProductQty": 2,
"ProductPrice": 15,
"ProductDiscount": 0,
"ProductTotal": 30,
"LineItemLocation": "OAK",
"LineItemShippingCarrier": "UPS",
"LineItemShippingMethod": "UPS Ground",
"LineItemTrackingNumber": "221133",
"LineItemShippingCost": "0.00",
"LineItemShippingDate": "07-08-2021",
"LineItemStatus": "Created,"
},
{
"OrderLineNo": "1",
"ProductsName": "Test Matrix Product2",
"ProductCode": "TMP2",
"MatrixSKUCode": "13420",
"SerialNo": "",
"ProductNotes": "Product notes goes here.",
"ProductsQuantityShipped": "0",
"ProductsQuantitySentToShipstation": "0",
"ProductQty": 2,
"ProductPrice": 5,
"ProductDiscount": 0,
"ProductTotal": 10,
"LineItemLocation": "OAK",
"LineItemShippingCarrier": "UPS",
"LineItemShippingMethod": "UPS Ground",
"LineItemTrackingNumber": "221133",
"LineItemShippingCost": "0.00",
"LineItemShippingDate": "07-08-2021",
"LineItemStatus": "Created,"
}
]
}
}
],
"TotalRecords": 1,
"CurrentPage": 1,
"TotalPages": 1,
"PageSize": 50
}
}
<Orders>
<Order>
<OrderNo>5531</OrderNo>
<AgilironOrderNo>2224</AgilironOrderNo>
<SalesOrderId>12224</SalesOrderId>
<ChannelId>2563</ChannelId>
<ChannelName>Amazon</ChannelName>
<OrderDate>01-24-2020 07:08:13</OrderDate>
<OrderDateUTC>01-24-2020 15:01:35</OrderDateUTC>
<ModifiedDate>01-24-2020 07:08:13</ModifiedDate>
<ModifiedTimeUTC>01-24-2020 15:05:56</ModifiedTimeUTC>
<Subject>Test New SalesOrder</Subject>
<PotentialName>New Potential</PotentialName>
<QuoteName>15march</QuoteName>
<AccountId>156961</AccountId>
<AccountName>Test Account</AccountName>
<AccountPhone>2344452</AccountPhone>
<AccountEmailAddress>[email protected]</AccountEmailAddress>
<ContactId>156962</ContactId>
<ContactFirstName>Contact Firstname</ContactFirstName>
<ContactLastName>Contact Lastname</ContactLastName>
<ContactPhone>56984663</ContactPhone>
<ContactEmailAddress>[email protected]</ContactEmailAddress>
<BillingName>Contact Firstname Contact Lastname</BillingName>
<BillingStreet>45623 Clean Drive</BillingStreet>
<BillingCity>Oakland</BillingCity>
<BillingState>CA</BillingState>
<BillingZipCode>94601</BillingZipCode>
<BillingCountry>UnitedStates</BillingCountry>
<ShipToName>Jane Doe</ShipToName>
<ShipToPhone>(415)675-3134</ShipToPhone>
<ShipToEmailAddress>[email protected]</ShipToEmailAddress>
<ShippingStreet>4567DoeCircle</ShippingStreet>
<ShippingCity>SanFrancisco</ShippingCity>
<ShippingState>CA</ShippingState>
<ShippingZipCode>94104</ShippingZipCode>
<ShippingCountry>UnitedStates</ShippingCountry>
<OrderDiscount>5.55</OrderDiscount>
<OrderDiscountCode></OrderDiscountCode>
<SubTotal>270.430</SubTotal>
<ShippingCost>6.750</ShippingCost>
<SalesTaxAuthority></SalesTaxAuthority>
<SalesTaxes>24.250</SalesTaxes>
<GrandTotal>301.430</GrandTotal>
<DefaultCurrency></DefaultCurrency>
<ExchangeRate></ExchangeRate>
<Status>Created,Paid,</Status>
<ShippingStatus>Ready to Pick,</ShippingStatus>
<AdditionalFees>3.45</AdditionalFees>
<DefaultPriceBook>Default</DefaultPriceBook>
<PaymentLineItems>
<Payment>
<PaymentMethod>Cash</PaymentMethod>
<PaymentAmount>9</PaymentAmount>
<PaymentDate>2021-01-19</PaymentDate>
<AmountDue>6</AmountDue>
</Payment>
<Payment>
<PaymentMethod>Check</PaymentMethod>
<PaymentAmount>11</PaymentAmount>
<PaymentDate>2021-01-20</PaymentDate>
<CheckNumber></CheckNumber>
<CheckWriter>Test</CheckWriter>
<AmountDue>6</AmountDue>
</Payment>
</PaymentLineItems>
<DueDate>01-24-2020</DueDate>
<InvoiceNo>1881</InvoiceNo>
<InvoiceDate>07-08-2021</InvoiceDate>
<CallDate>01-24-2020</CallDate>
<CustomerNo>23276</CustomerNo>
<AssignedTo>admin</AssignedTo>
<ExportToQuickbooks>2</ExportToQuickbooks>
<Type>ASAP</Type>
<Priority>Standard</Priority>
<Pending>Nothing</Pending>
<Salescommission>30.140</Salescommission>
<TermsAndConditions>Prepaid</TermsAndConditions>
<Description>Order notes goes here.</Description>
<Carrier>USPS</Carrier>
<ShippingMethod>Priority Mail 2-Day</ShippingMethod>
<DeliverFrom>OAK</DeliverFrom>
<ShippingDate></ShippingDate>
<TrackingNo></TrackingNo>
<ActualShippingCost>23.00</ActualShippingCost>
<SpecialHandling>Special Instructions goes here.</SpecialHandling>
<ShipQPriority>Standard</ShipQPriority>
<BackorderHandling>ShipAsAvailable</BackorderHandling>
<PacklistType>Show Company Details and Logo</PacklistType>
<AmazonPrimeShipping>Yes</AmazonPrimeShipping>
<Cancelled>No</Cancelled>
<OnHold>No</OnHold>
<RelatedPOs></RelatedPOs>
<RelatedDropShipPOs></RelatedDropShipPOs>
<OrdersCustomFields>
<CustomField>
<Name>CustomFied1</Name>
<Value>Custom info 1</Value>
</CustomField>
<CustomField>
<Name>CustomFied2</Name>
<Value>Custom info 2</Value>
</CustomField>
</OrdersCustomFields>
<OrderDetails>
<OD>
<OrderLineNo>0</OrderLineNo>
<ProductsName>Test New Product1</ProductsName>
<ProductCode>TNP1</ProductCode>
<MatrixSKUCode>0</MatrixSKUCode>
<SerialNo></SerialNo>
<ProductNotes>Product notes goes here.</ProductNotes>
<ProductsQuantityShipped>0</ProductsQuantityShipped>
<ProductsQuantitySentToShipstation>0</ProductsQuantitySentToShipstation>
<ProductQty>2</ProductQty>
<ProductPrice>15</ProductPrice>
<ProductDiscount>0</ProductDiscount>
<ProductTotal>30</ProductTotal>
<LineItemLocation>OAK</LineItemLocation>
<LineItemShippingCarrier>UPS</LineItemShippingCarrier>
<LineItemShippingMethod>UPS Ground</LineItemShippingMethod>
<LineItemTrackingNumber>221133</LineItemTrackingNumber>
<LineItemShippingCost>0.00</LineItemShippingCost>
<LineItemShippingDate>07-08-2021</LineItemShippingDate>
<LineItemStatus>Created,</LineItemStatus>
</OD>
<OD>
<OrderLineNo>1</OrderLineNo>
<ProductsName>Test Matrix Product2</ProductsName>
<ProductCode>TMP2</ProductCode>
<MatrixSKUCode>13420</MatrixSKUCode>
<SerialNo></SerialNo>
<ProductNotes>Product notes goes here.</ProductNotes>
<ProductsQuantityShipped>0</ProductsQuantityShipped>
<ProductsQuantitySentToShipstation>0</ProductsQuantitySentToShipstation>
<ProductQty>2</ProductQty>
<ProductPrice>5</ProductPrice>
<ProductDiscount>0</ProductDiscount>
<ProductTotal>10</ProductTotal>
<LineItemLocation>OAK</LineItemLocation>
<LineItemShippingCarrier>UPS</LineItemShippingCarrier>
<LineItemShippingMethod>UPS Ground</LineItemShippingMethod>
<LineItemTrackingNumber>221133</LineItemTrackingNumber>
<LineItemShippingCost>0.00</LineItemShippingCost>
<LineItemShippingDate>07-08-2021</LineItemShippingDate>
<LineItemStatus>Created,</LineItemStatus>
</OD>
</OrderDetails>
</Order>
<TotalRecords>1</TotalRecords>
<CurrentPage>1</CurrentPage>
<TotalPages>1</TotalPages>
<PageSize>50</PageSize>
</Orders>
WADL
<?xml version="1.0" encoding="utf-8"?>
<application>
<resources base="https://{yourCompany}.agiliron.net/agiliron/api-40/">
<resource path="SalesOrder">
<method name="GET">
<resource path="{filter}">
<request>
<param name="key" type="xsd:string" style="query" required="true"/>
</request>
<response status="200">
<representation mediaType="application/xml" element="yn:ResultSet"/>
</response>
<response status="400">
<representation mediaType="application/xml" element="ya:Error"/>
</response>
</method>
</resource>
</resources>
</application>
Updated 21 days ago