API ReferenceGuides
Guides
Home

Read SalesReturn

Retrieves the details of a SalesReturn object that has been previously created.

Suggest Edits

Parameters

Path Params
yourCompany:string
The Company name need to passed in the base URL.For eg. if you enter xyzcompany name, the url https://{yourCompany}.agiliron.net/agiliron/api-40.php/SalesReturn will change to https://xyzcompany.agiliron.net/agiliron/api-40.php/SalesReturn
Query Params
filter:string
In this parameter fieldname needs to be provided with condition and value
to fetch related details.for eg. Subject,eq,Salesreturn subject

1) To fetch SalesReturn with status is equal to shipped and custom field(Test CheckBox) value is no or off, the following url must be used

https://xyzcompany.agiliron.net/agiliron/api-40/SalesReturn?filter=Status,eq,Created | Invoiced | Shipped;Test CheckBox,eq,0&key=xyzkey

2) To fetch SalesReturn with created date between 01-15-2020 to 01-31-2020 (Use | between two dates), the following url must be used

https://xyzcompany.agiliron.net/agiliron/api-40/SalesReturn?filter=OrderDate,bt,01-15-2020 | 01-31-2020&key=xyzkey

3) To fetch SalesReturn with created datetime between 01-15-2020 01:03:10 to 01-31-2020 20:00:00 (Use | between two dates), the following url must be used

https://xyzcompany.agiliron.net/agiliron/api-40/SalesReturn?filter=OrderDate,bt,01-15-2020 01:03:10| 01-31-2020 20:00:00&key=xyzkey

4) To fetch SalesReturn with Deliverto 'OAK' OR 'PDX' (Use OR between two values), the following url must be used

https://xyzcompany.agiliron.net/agiliron/api-40/SalesReturn?filter=DeliverTo,eq,OAK OR PDX&key=xyzkey

List of condition abbrevations to be used:
"cs": contain string (string contains value)
"sw": start with (string starts with value)
"ew": end with (string end with value)
"neq": not equal (string or number should not match)
"eq": equal (string or number matches exactly)
"lt": lower than (number is lower than value)
"le": lower or equal (number is lower than or equal to value)
"ge": greater or equal (number is higher than or equal to value)
"gt": greater than (number is higher than value)
"bt": between (number is between two comma separated values)
customview:string
In this parameter customview name needs to be provided to fetch related details.For eg. To fetch SalesReturn customview with name as ABC Customview, the following url must be used

https://xyzcompany.agiliron.net/agiliron/api-40/SalesReturn?customview=ABC Customview&key=xyzkey
page:int
Page number needs to be passed in this variable ,to paginate the response.For eg. To fetch SalesReturn with status is equal to shipped and custom field(Test CheckBox) value is no or off and page equal to 10, the following url must be used

https://xyzcompany.agiliron.net/agiliron/api-40/SalesReturn?filter=Status,eq,Created | Invoiced | Shipped;Test CheckBox,eq,0&page=10&key=xyzkey
pageSize:int
In this parameter pageSize number needs to be provided to fetch related page details.For eg. To fetch SalesReturn with status is equal to shipped and custom field(Test CheckBox) value is no or off and page size equal to 10, the following url must be used

https://xyzcompany.agiliron.net/agiliron/api-40/SalesReturn?filter=Status,eq,Created | Invoiced | Shipped;Test CheckBox,eq,0&pageSize=10&key=xyzkey
Header Params
Accept:string
API key needs to be passed in this variable.The option to enter API key will appear when you click on Try it button.
Query Auth
key:string
API key needs to be passed in this variable.The option to enter API key will appear when you click on Try it button.This will be the first option in AUTHENTICATION block.Default is SET to 0.
Header Auth
apiKey:string
Dedicated API key needs to be passed in this variable via header.The option to enter API key will appear when you click on Try it button.This will be the second option in AUTHENTICATION block.Default is SET to 0.

Sample Code
NOTE: For SalesReturn ,

  • SalesReturnId field contains SalesReturn Id.
  • OrderNo field contains RMA Number.
  • AgilironOrderNo field contains Return no.
  • RelatedSalesOrders field contains SalesOrder No.
{
	"SalesReturns": {
		"Order": [{
			"OrderNo": "2794",
			"AgilironOrderNo": "3001",
			"SalesReturnId": "13001",
			"OrderDate": "01-24-2020 08:33:59",
			"OrderDateUTC": "01-24-2020 15:01:35",
			"ModifiedDate": "01-24-2020 06:39:02",
			"ModifiedTimeUTC": "01-24-2020 15:05:56",
			"Subject": "Test New Sales return",
			"AccountId": "156961",
			"AccountName": "Test Account",
			"AccountPhone": "23444522",
			"AccountEmailAddress": "[email protected]",
			"ContactId": "156962",
			"ContactFirstName": "John",
			"ContactLastName": "Doe",
			"ContactPhone": "41533345",
			"ContactEmailAddress": "[email protected]",
			"Fax": "",
			"DueDate": "",
			"BillingName": "John Doe",
			"BillingStreet": "4567DoeCircle",
			"BillingCity": "SanFrancisco",
			"BillingState": "CA",
			"BillingZipCode": "94104",
			"BillingCountry": "UnitedStates",
			"ShipToName": "",
			"ShipToPhone": "(415)675-3134",
			"ShipToEmailAddress": "[email protected]",
			"ShippingStreet": "4567DoeCircle",
			"ShippingCity": "SanFrancisco",
			"ShippingState": "CA",
			"ShippingZipCode": "94104",
			"ShippingCountry": "UnitedStates",
			"OrderDiscount": "",
			"SubTotal": "455.780",
			"ShippingCost": "",
			"SalesTaxAuthority": "",
			"SalesTaxes": "0.000",
			"GrandTotal": "462.530",
			"DefaultCurrency": "",
			"ExchangeRate": "0.00000",
			"Status": "Created,Invoiced,",
			"PaymentMethod": "Cash",
			"CreditCardType": "",
			"CheckNumber": "",
			"CreditCardOwner": "JohnDoe",
			"CheckWriter": "",
			"PaymentAmount": "462.530",
			"PaymentDate": "",
			"AssignedTo": "admin",
			"ExportToQuickbooks": "2",
			"TermsAndConditions": "Prepaid",
			"Description": "Order notes goes here.",
			"Carrier": "",
			"ShippingMethod": "",
			"DeliverTo": "OAK",
			"RMANumber": "5012323123223",
			"TrackingNo": "",
			"RelatedSalesOrders": "2308",
			"OrdersCustomFields": {
				"CustomField": [{
						"Name": "CustomFied1",
						"Value": "Custom info 1"
					},
					{
						"Name": "CustomFied2",
						"Value": "Custom info 2"
					}
				]
			},
			"OrderDetails": {
				"OD": [{
						"ProductsName": "Test New Product1",
						"ProductCode": "TNP1",
						"MatrixSKUCode": "0",
						"SerialNo": "",
						"ProductNotes": "Product notes goes here.",
						"ProductQty": "2",
						"ProductPrice": "15",
						"ProductDiscount": "0",
						"ProductTotal": "30"
					},
					{
						"ProductsName": "Test New Product2",
						"ProductCode": "TNP2",
						"MatrixSKUCode": "0",
						"SerialNo": "",
						"ProductNotes": "Product notes goes here.",
						"ProductQty": "2",
						"ProductPrice": "5",
						"ProductDiscount": "0",
						"ProductTotal": "10"
					}
				]
			}
		}],
		"TotalRecords": "1",
		"CurrentPage": "1",
		"TotalPages": "1",
		"PageSize": "50"
	}
}

<SalesReturns>
  <Order>
    <OrderNo>2794</OrderNo>
    <AgilironOrderNo>3001</AgilironOrderNo>
    <SalesReturnId>13001</SalesReturnId>
    <OrderDate>01-24-2020 08:33:59</OrderDate>
    <OrderDateUTC>01-24-2020 15:01:35</OrderDateUTC>
    <ModifiedDate>01-24-2020 06:39:02</ModifiedDate>
    <ModifiedTimeUTC>01-24-2020 15:05:56</ModifiedTimeUTC>
    <Subject>Test New Sales return</Subject>
    <AccountId>156961</AccountId>
    <AccountName>Test Account</AccountName>
    <AccountPhone>23444522</AccountPhone>
    <AccountEmailAddress>[email protected]</AccountEmailAddress>
    <ContactId>156962</ContactId>
    <ContactFirstName>John</ContactFirstName>
    <ContactLastName>Doe</ContactLastName>
    <ContactPhone>41533345</ContactPhone>
    <ContactEmailAddress>[email protected]</ContactEmailAddress>
    <Fax></Fax>
    <DueDate></DueDate>
    <BillingName>John Doe</BillingName>
    <BillingStreet>4567DoeCircle</BillingStreet>
    <BillingCity>SanFrancisco</BillingCity>
    <BillingState>CA</BillingState>
    <BillingZipCode>94104</BillingZipCode>
    <BillingCountry>UnitedStates</BillingCountry>
    <ShipToName></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></OrderDiscount>
    <SubTotal>455.780</SubTotal>
    <ShippingCost></ShippingCost>
    <SalesTaxAuthority></SalesTaxAuthority>
    <SalesTaxes>0.000</SalesTaxes>
    <GrandTotal>462.530</GrandTotal>
    <DefaultCurrency></DefaultCurrency>
    <ExchangeRate>0.00000</ExchangeRate>
    <Status>Created,Invoiced,</Status>
    <PaymentMethod>Cash</PaymentMethod>
    <CreditCardType></CreditCardType>
    <CheckNumber></CheckNumber>
    <CreditCardOwner>JohnDoe</CreditCardOwner>
    <CheckWriter></CheckWriter>
    <PaymentAmount>462.530</PaymentAmount>
    <PaymentDate></PaymentDate>
    <AssignedTo>admin</AssignedTo>
    <ExportToQuickbooks>2</ExportToQuickbooks>
    <TermsAndConditions>Prepaid</TermsAndConditions>
    <Description>Order notes goes here.</Description>
    <Carrier></Carrier>
    <ShippingMethod></ShippingMethod>
    <DeliverTo>OAK</DeliverTo>
    <RMANumber>5012323123223</RMANumber>
    <TrackingNo></TrackingNo>
    <RelatedSalesOrders>2308</RelatedSalesOrders>
    <OrdersCustomFields>
      <CustomField>
        <Name>CustomFied1</Name>
        <Value>Custom info 1</Value>
      </CustomField>
      <CustomField>
        <Name>CustomFied2</Name>
        <Value>Custom info 2</Value>
      </CustomField>
    </OrdersCustomFields>
    <OrderDetails>
      <OD>
        <ProductsName>Test New Product1</ProductsName>
        <ProductCode>TNP1</ProductCode>
        <MatrixSKUCode>0</MatrixSKUCode>
        <SerialNo></SerialNo>
        <ProductNotes>Product notes goes here.</ProductNotes>
        <ProductQty>2</ProductQty>
        <ProductPrice>15</ProductPrice>
        <ProductDiscount>0</ProductDiscount>
        <ProductTotal>30</ProductTotal>
      </OD>
      <OD>
        <ProductsName>Test New Product2</ProductsName>
        <ProductCode>TNP2</ProductCode>
        <MatrixSKUCode>0</MatrixSKUCode>
        <SerialNo></SerialNo>
        <ProductNotes>Product notes goes here.</ProductNotes>
        <ProductQty>2</ProductQty>
        <ProductPrice>5</ProductPrice>
        <ProductDiscount>0</ProductDiscount>
        <ProductTotal>10</ProductTotal>
      </OD>
    </OrderDetails>
  </Order>
  <TotalRecords>1</TotalRecords>
  <CurrentPage>1</CurrentPage>
  <TotalPages>1</TotalPages>
  <PageSize>50</PageSize>
</SalesReturns>

WADL

<?xml version="1.0" encoding="utf-8"?>
<application>
   <resources base="https://{yourCompany}.agiliron.net/agiliron/api-40/">
     <resource path="SalesReturn">
       <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 over 1 year ago

© Copyright 2022 Agiliron - All Rights Reserved.