AllProductList
ApBill
GET ApBill/GetApBill?VendorID={VendorID}&InvoiceNumber={InvoiceNumber}&DueDate={DueDate}&Status={Status}&apBillGuid={apBillGuid} |
Returns AP Bill |
POST ApBill/PostApBill |
Creates a new AP Bill. |
Applicator
GET Applicator/GetApplicator?applicatorID={applicatorID}&locationIDFilter={locationIDFilter} |
Returns a list of Applicators and the information available for each. |
ApPurchaseOrder
GET ApPurchaseOrder/GetApPo?vendorId={vendorId}&poNumber={poNumber}&poDate={poDate}&status={status}&apPoGuid={apPoGuid} |
Returns AP Purchase Orders |
BidCriteria
GET BidCriteria/GetShipmentBidCriteria?IncludeInactive={IncludeInactive}&AddBlankItem={AddBlankItem} |
Returns a list of Bid Criteria IDs. |
BlendProductSet
GET BlendProductSet/GetBlendProductSet?blendSetDescription={blendSetDescription}&activeFilter={activeFilter}&locationIdOrGuid={locationIdOrGuid}&blendSetType={blendSetType}&automatedBlenderType={automatedBlenderType} |
Returns a list of Blend Product Sets and their detailed information. |
BlendTicket
GET BlendTicket/GetBlendTicketData?ticket={ticket}&growerIdOrGuid={growerIdOrGuid}&fieldIdOrGuid={fieldIdOrGuid}&locationIdOrGuid={locationIdOrGuid}&startDate={startDate}&endDate={endDate}&loadedStartDate={loadedStartDate}&loadedEndDate={loadedEndDate}&appliedStartDate={appliedStartDate}&appliedEndDate={appliedEndDate}&lastModifiedOnOrAfterUtc={lastModifiedOnOrAfterUtc}&ldBl={ldBl}&vd={vd}&inv={inv}&vrt={vrt}&dL={dL}&aBt={aBt} |
Returns a list of Blend Tickets filtered by ticket number, grower, field, location, and date(s). |
PUT BlendTicket/PutBlendTicket |
Update a blend ticket. |
POST BlendTicket/PostBlendTicket |
Add a blend ticket. |
BlendTicketList
GET BlendTicketList/GetBlendTicket?custID={custID}&fieldID={fieldID}&Location={Location}&StartDate={StartDate}&EndDate={EndDate} |
Returns a list of blend tickets. |
Booking
GET Booking/GetBooking?StartDate={StartDate}&EndDate={EndDate}&lastModifiedOnOrAfterUtc={lastModifiedOnOrAfterUtc}&lastModifiedOnOrBeforeUtc={lastModifiedOnOrBeforeUtc}&custID={custID}&bookGuid={bookGuid} |
Returns booking data. |
POST Booking/PostBooking |
Creates a new Booking. |
GET Booking/GetPlannedPaymentMethodList |
Returns a list of the Booking Pay Methods |
Commodity
GET Commodity/GetCommodity?FilterListInActive={FilterListInActive} |
Returns a list of Commodities. |
CommodityCustomerBalance
GET CommodityCustomerBalance/GetCommodityGrainBalance?CustID={CustID}&SplitOpenStorageOnHold={SplitOpenStorageOnHold} |
Returns a list of Commodity Grain Balances. |
Container
ContainerActivity
GET ContainerActivity/GetContainerActivity?containerKey={containerKey}&lastActivityOnly={lastActivityOnly} |
Returns a list of activity records for a container |
POST ContainerActivity/PostContainerActivity |
Creates a container activity record |
POST ContainerActivity/ValidatePostContainerActivity |
Validates the creation of a container activity record |
ContractStatus
GET ContractStatus/GetPurchaseContractStatus |
Returns a list of Contract Status. |
ContractType
GET ContractType/GetPurchaseContractType |
Returns a list of Contract Types. |
CreditCheck
GET CreditCheck/GetCustomerCreditCheck?CustID={CustID} |
Returns the customers credit check values. |
CreditStatus
GET CreditStatus/GetCreditStatus?creditStatus={creditStatus} |
Returns credit status details. |
Crop
GET Crop/GetCrop?name={name}&SMPCropGUID={SMPCropGUID} |
Returns a list of crop types and crop maintenance information. |
CropChemistry
GET CropChemistry/GetCropChemistry?name={name}&activeFilter={activeFilter} |
Returns a list of crop chemistry data. |
CropZonesForFields
POST CropZonesForFields/GetCropZonesForFields |
Returns CropZone Name, Crop Year, GIS Acres, and optional Field Information as filtered by the list of fields supplied |
Customer
GET Customer/GetCustomer?SearchType={SearchType}&SearchTypeValue={SearchTypeValue}&SearchTerm={SearchTerm}&phoneNumber={phoneNumber} |
Returns a list of customers. |
POST Customer/GetCustomerDetailList |
Returns a list of customers. |
POST Customer/PostCustomer |
Add a Customer. |
PUT Customer/PutCustomer |
Edit a Customer |
CustomerAddress
GET CustomerAddress/GetCustomerAddress?CustomerID={CustomerID}&BillToOrShipTo={BillToOrShipTo}&BillToShipToName={BillToShipToName} |
Returns a list of customer addresses. |
CustomerBooking
GET CustomerBooking/GetCustomerBooking?CustID={CustID} |
Returns a list of customer bookings. |
CustomerBusinessInfluence
GET CustomerBusinessInfluence/GetCustomerBusinessInfluences?customerId={customerId} |
Returns a list of business influence types and the customers associated with the business influence. |
CustomerClassification
GET CustomerClassification/GetCustomerClassification |
Returns a list of customer classifications. |
CustomerList
POST CustomerList/GetCustomerList |
Returns a list of customers selected with CustomerGUIDs or CustomerIDs and all customers that match a Location, Salesperson, Classification, and First Name or Last Name. |
CustomerPayoff
GET CustomerPayoff/GetCustomerPayoff?CustID={CustID}&AsOfDate={AsOfDate}&DueBefore={DueBefore}&MaximizeDiscounts={MaximizeDiscounts}&IncludeUAC={IncludeUAC}&StockClassification={StockClassification} |
Returns the customers payoff amount and open invoices that make up the payoff amount. |
CustomerPriceLookup
GET CustomerPriceLookup/GetCustomerPriceLookup?CustID={CustID}&DeptID={DeptID}&ProdID={ProdID}&AdditionalDatabase={AdditionalDatabase} |
Gets customer default price and price level data. |
CustomerQuote
GET CustomerQuote/GetCustomerQuote?CustID={CustID}&DeptID={DeptID}&ProdID={ProdID} |
Returns customer quotes. |
CustomerStatement
GET CustomerStatement/GetStatementURL?growerIdorGuid={growerIdorGuid}&calendarMonth={calendarMonth}&year={year}&statementType={statementType} |
Returns link to PDF of Customer's Statement for time period. |
DeliveryTicket
GET DeliveryTicket/GetDeliveryTicket?TicketNumber={TicketNumber}&LocationID={LocationID}&TicketDate={TicketDate}&CustomerID={CustomerID}&Voided={Voided}&Status={Status}&ControlNumber={ControlNumber}&LastModifiedUTC={LastModifiedUTC} |
Returns a Delivery Ticket |
POST DeliveryTicket/PostDeliveryTicket |
Creates a new Delivery Ticket |
PUT DeliveryTicket/PutDeliveryTicket |
Updates a Delivery Ticket. |
DeliveryTicketAssigned
GET DeliveryTicketAssigned/GetAssignedToUser?userId={userId} |
Gets the count of the Delivery Tickets assigned to this Agvance user. |
POST DeliveryTicketAssigned/PostAssignedToCustomer |
Gets the count of the Delivery Tickets assigned to the customers. |
DeliveryTicketLock
GET DeliveryTicketLock/PutDeliveryTicketLock?userId={userId}&uniqueKey={uniqueKey}&doLock={doLock} |
Gets (and optionally sets) the locked status of a Delivery Ticket. |
PUT DeliveryTicketLock/PutDeliveryTicketUnLock?userId={userId}&uniqueKey={uniqueKey} |
Unlocks a Delivery Ticket. |
Department
GET Department/GetDepartmentByLocationID?LocationID={LocationID}&ProductID={ProductID} |
Returns a list of departments by location ID. |
GET Department/GetDepartment?LocationName={LocationName}&ProductID={ProductID} |
Returns a list of departments by location name. |
DisabledProduct
GET DisabledProduct/GetDisabledSeedProduct?LikeProduct={LikeProduct} |
Returns a list of disabled products. |
EmailPurchaseContract
GET EmailPurchaseContract/GetPurchaseContractEmailAddresses?custID={custID} |
Returns a an email address for the purchase contract grower. |
Farm
Field
FieldsForCustomers
POST FieldsForCustomers/GetFieldsForCustomersList |
Returns FarmID, Farm Name, FieldID, Field Name, Reported Acres, Last Planted Date, Field Boundary, Field GUID, Farm GUID, Grower GUID, Grower Name (first and last) as filtered by the list of growers, the fieldIDFilter, and the fieldActiveStatusFilter |
FuturesContract
POST FuturesContract/PostFuturesContract |
Create a futures contract |
FuturesMonth
GET FuturesMonth/GetFuturesMonthsList?Commodity={Commodity}&Location={Location}&Exchange={Exchange}&BidCriteria={BidCriteria}&lastModifiedOnOrAfterUtc={lastModifiedOnOrAfterUtc}&futMonthOnOrAfterEndDate={futMonthOnOrAfterEndDate} |
Returns a list of Futures Months where the Futures Month End Date has not yet past. If the lastModifiedOnOrAfterUtc filter is used, the futures month end date filter is suppressed. |
PUT FuturesMonth/PutFuturesMonth |
Update basis prices. |
POST FuturesMonth/PostBasisLockout?Unlock={Unlock} |
Set preference to lock Agvance users from changing basis prices. |
POST FuturesMonth/PostFuturesMonthAddOrUpdate |
Save to the Agvance database the Futures Month Pricing Information |
GrowerOrder
GET GrowerOrder/GetGrowerOrder?DeptID={DeptID}&ProdID={ProdID}&GrowerID={GrowerID}&LocationID={LocationID}&GrowerOrderNumber={GrowerOrderNumber} |
Returns a list of grower orders |
InventoryAdjustment
GET InventoryAdjustment/GetInventoryAdjustmentTypes |
Returns a list of Inventory Adjustment Types. |
GET InventoryAdjustment/GetInventoryAdjustments?referenceNumber={referenceNumber}&locationIdOrGuid={locationIdOrGuid}&startDate={startDate}&endDate={endDate}&voided={voided} |
Returns a list of Inventory Adjustments. |
POST InventoryAdjustment/PostInventoryAdjustment |
Add an inventory adjustment. |
InventoryCheck
GET InventoryCheck/GetInventoryCheck?DeptID={DeptID}&ProdID={ProdID}&LocationID={LocationID} |
Returns inventory details for a product. |
InventoryCheckList
POST InventoryCheckList/GetInventoryCheckList |
Returns a list of inventory check details. |
InventoryReceived
GET InventoryReceived/GetInventoryReceived?vendorId={vendorId}&ticketNumber={ticketNumber}&statusType={statusType} |
Returns a list of tickets for products received through Agvance Warehouse / Mobile Inventory |
POST InventoryReceived/PostInventoryReceived |
Creates inventory received records |
PUT InventoryReceived/PutInventoryReceived |
Updates inventory received records |
InventorySnapshot
Invoice
JournalEntry
GET JournalEntry/GetJournalEntry?createdOnOrAfterUtc={createdOnOrAfterUtc}&includeAccountAttributesList={includeAccountAttributesList} |
Returns a list of Journal Entries filtered by the date and time created in UTC format. The request and response require the use of "Paged" records using Header Keys. |
POST JournalEntry/PostJournalEntry |
Creates a new Journal Entry |
POST JournalEntry/PostReverseJournalEntry |
Reverses a Journal Entry |
PUT JournalEntry/PutJournalEntry |
Updates an existing Journal Entry |
Location
GET Location/GetLocation?IncludeInactive={IncludeInactive} |
Returns a list of locations. |
LpTank
GET LpTank/GetLpTankInfo?CustomerID={CustomerID}&TankNumber={TankNumber}&LpTankGuid={LpTankGuid} |
Returns a list of Tanks. |
GET LpTank/GetLpTankDeliverInfo?CustomerID={CustomerID}&TankNumber={TankNumber}&DeliveryDate={DeliveryDate} |
Returns a list of Tank Deliveries. |
POST LpTank/PostTankReading |
Create a Tank Reading entry |
POST LpTank/PostTank |
Create a Tank |
PUT LpTank/PutTank |
Update a Tank |
ManufactureInventory
POST ManufactureInventory/PostManufactureInventory |
Creates a manufacture inventory record. |
Map
GET Map/GetFieldGuidFromLayerHash?LayerIDHash={LayerIDHash} |
Get the FieldGUID from the LayerIDHash provided |
MiscComment
GET MiscComment/GetMiscComment?Type={Type} |
Returns all Misc Comments for a comment type |
MotorFuel
GET MotorFuel/GetMotorFuelSetupInfo |
Gets the motor fuel setup information. |
OpRegionList
Payment
GET Payment/GetPayment?CustomerID={CustomerID}&PaymentDate={PaymentDate}&PaymentStartDate={PaymentStartDate}&PaymentEndDate={PaymentEndDate}&PaymentAmount={PaymentAmount}&PaymentLocationID={PaymentLocationID}&PaymentType={PaymentType}&PrePayYesNo={PrePayYesNo}&InvoiceNumber={InvoiceNumber} |
Returns payment information. |
POST Payment/PostReceivedOnAccount |
Creates a new Received on Account payment. |
POST Payment/PostBudgetPayment |
Creates a new Budget payment on a memo invoice. |
PaymentTerms
GET PaymentTerms/GetPaymentTerm?id={id}&effectiveDate={effectiveDate}&activeDetailLineFilter={activeDetailLineFilter} |
Returns a list of Payment Terms |
PhysicalInventory
GET PhysicalInventory/GetPhysicalInventory?UserID={UserID} |
Returns Physical Inventory Count |
Placement
GET Placement/GetPlacement?name={name} |
Returns a list of Placements (the method in which product is applied to a field, i.e., broadcast, sprayed, knifed, etc.) |
Plan
GET Plan/GetFieldPlanDetail?GrowerID={GrowerID}&FieldID={FieldID}&AreaID={AreaID}&PlanID={PlanID}&FldPlanUniqueID={FldPlanUniqueID}&Location={Location}&StartDate={StartDate}&EndDate={EndDate} |
Returns a list of field plans. |
POST Plan/PostFieldPlan |
Add a Field Plan. |
PUT Plan/PutFieldPlan |
Edit a Field Plan. |
PlanList
GET PlanList/GetFieldPlan?CustID={CustID}&FieldID={FieldID}&Location={Location}&StartDate={StartDate}&EndDate={EndDate} |
Returns a list of field plans. |
PremiumDiscount
GET PremiumDiscount/GetPremiumDiscountSchedule?Commodity={Commodity}&GradeFactor={GradeFactor} |
Returns a list of Premium Discount Schedules. |
Price
GET Price/GetPrice?CustID={CustID}&DeptID={DeptID}&ProdID={ProdID} |
Returns the heading, price, and level for a customer/product. |
PriceLevel
GET PriceLevel/GetCosts?DeptID={DeptID}&ProdID={ProdID} |
Returns a list of price/cost levels. |
PUT PriceLevel/PutProductPriceLevel |
Edits an existing product. |
Product
ProductList
POST ProductList/GetProductList?lastModifiedOnOrAfterUtc={lastModifiedOnOrAfterUtc}&lastModifiedOnOrBeforeUtc={lastModifiedOnOrBeforeUtc} |
Returns a list of products based on a product unique key, productGUID, or departmentId/productId combination. |
ProductPriceLevel
GET ProductPriceLevel/PriceLevelGetProduct?DeptID={DeptID} |
Returns a list of products. |
ProductQuote
GET ProductQuote/GetProductQuoteList?custId={custId}&deptId={deptId}&prodId={prodId} |
Returns a listing of product quotes containg the ProductName, Number, Price, and QuoteDate. |
GET ProductQuote/GetProductQuote?QuoteNumber={QuoteNumber} |
Gets a product quotes. |
POST ProductQuote/PostProductQuote |
Create a product quote. |
PUT ProductQuote/PutProductQuote |
Update a product quote. |
ProductReplacementCost
PUT ProductReplacementCost/PutProductReplacementCost |
Updates replacement costs |
ProductUse
PurchaseContract
GET PurchaseContract/GetPurchaseContractByContractByLocationID?Contract={Contract}&Location={Location} |
Returns a purchase contract by contract number and location. |
POST PurchaseContract/PostPurchaseContract |
Create a purchase contract |
GET PurchaseContract/GetPurchaseContract?CustID={CustID}&Location={Location}&Contract={Contract}&Commodity={Commodity}&ContractStatus={ContractStatus}&ContractType={ContractType}&UseDateEst={UseDateEst}&StartDate={StartDate}&EndDate={EndDate}&BidCriteria={BidCriteria}&ShippingDestination={ShippingDestination}&lastModifiedOnOrAfterUtc={lastModifiedOnOrAfterUtc}&lastModifiedOnOrBeforeUtc={lastModifiedOnOrBeforeUtc} |
Returns a list of purchase contract by location and any optional parameters provided. |
PurchaseInvoice
GET PurchaseInvoice/GetPurchaseInvoice?VendorID={VendorID}&InvoiceNumber={InvoiceNumber} |
Returns a purchase invoice. |
POST PurchaseInvoice/PostPurchaseInvoice |
Creates a new purchase invoice. |
PurchaseInvoiceList
PurchaseOrder
PurchaseReceipt
GET PurchaseReceipt/GetPurchaseReceiptByVendorIDByTicketNumber?VendID={VendID}&TicketNum={TicketNum} |
Returns purchase receipt |
POST PurchaseReceipt/PostPurchaseReceipt |
Creates a new purchase receipt |
PurchaseReceiptList
SalesContract
SalesOrderDiscount
GET SalesOrderDiscount/GetSalesOrderDiscount |
Returns a list of sales order discounts. |
POST SalesOrderDiscount/GetSalesOrderDiscountDetailList |
Returns a list of sales order discount details for the sales order passed in. |
POST SalesOrderDiscount/GetSalesOrderNetPriceList?CustID={CustID} |
Returns a list of sales order net prices. |
SalesOrderTermDiscount
POST SalesOrderTermDiscount/GetSalesOrderPaymentTermDiscountList?LocationID={LocationID}&CustID={CustID} |
Returns a list of sales order term discounts. |
SalesOrderV2
GET SalesOrderV2/GetSalesOrderV2?salesOrderGuid={salesOrderGuid}&orderNumber={orderNumber}&custIdOrGuid={custIdOrGuid}&statusFilter={statusFilter}&processedFilter={processedFilter} |
Returns a list of Sales Orders |
POST SalesOrderV2/PostSalesOrderV2 |
Creates a Sales Order |
PUT SalesOrderV2/PutSalesOrderV2 |
Updates a Sales Order |
DELETE SalesOrderV2/DeleteSalesOrderV2?salesOrderGuid={salesOrderGuid} |
Deletes a Sales Order. |
Salesperson
GET Salesperson/GetSalesperson?salesPersonSearch={salesPersonSearch}&salesPersonSearchType={salesPersonSearchType}&lastModifiedOnOrAfterUtc={lastModifiedOnOrAfterUtc} |
Returns a list of Salespeople. |
ScaleInterface
ScaleTicket
Settlement
ShippingDestination
GET ShippingDestination/GetShipmentDestination |
Returns a list of Shipping Destinations. |
SimilarProduct
GET SimilarProduct/GetSimilarProduct?LikeProduct={LikeProduct}&NotLikeProduct={NotLikeProduct} |
Returns a list of products based upon a LIKE and NOT LIKE criteria. |
TargetPest
GET TargetPest/GetTargetPest |
Returns a list of Target Pests. |
Technology
GET Technology/GetTechnologyLicenses?TransactionDate={TransactionDate}&ProductGuid={ProductGuid}&CustomerGuid={CustomerGuid}&DeptID={DeptID}&ProdID={ProdID}&CustID={CustID} |
Returns the technology license information about a single customer and product for a given transaction date. To retrieve a list of technology licenses, provide the following: 1. Transaction Date 2. CustID or CustGuid 3. DeptID and ProdID -or- ProductGuid |
GET Technology/GetTechnologyGroupCheck?TransactionType={TransactionType}&ProductGuid={ProductGuid}&DeptID={DeptID}&ProdID={ProdID} |
Returns the technology group check information for a transaction type and product. To retrieve the technology group check information, provide the following: 1. TransactionType 2. DeptID and ProdID -or- ProductGuid |
ToDpr
GET ToDpr/GetGrainSettlementToDPR |
Returns a list of ToDPRs. |
User
POST User/PostLogout |
Method exposed only for legacy apps as it makes no changes in the API. Remote app should dispose of session internally. |
GET User/GetUser?userIdToFilterBy={userIdToFilterBy} |
Returns a list of users. |
UserCoded
GET UserCoded |
Validates user login. |
GET UserCoded/Login |
Validates user login. |
Vehicle
GET Vehicle/GetVehicle?active={active}&location={location}&type={type} |
Get a list of vehicles. |
PUT Vehicle/PutVehicle |
Edit a vehicle |
POST Vehicle/PostVehicle |
Create a new vehicle. |
Vendor
GET Vendor/GetVendor?location={location}&vendorID={vendorID}&activeFlag={activeFlag}&uniqueKey={uniqueKey}&vendorNameSearch={vendorNameSearch}&howToSearch={howToSearch}&vendorGuid={vendorGuid} |
Returns a list of Vendors |
POST Vendor/PostVendor |
Creates a new Vendor. |
PUT Vendor/PutVendor |
Updates a Vendor. |