AcctReports
POST AcctReports/GetVolumeStatementReport |
Generate a Volume Statement report |
AgrReports
POST AgrReports/GetGrowerSummaryReport |
Generate a Grower Summary report |
AgvanceUser
GET AgvanceUser/GetAgvanceUser?activeFilter={activeFilter}&userIdToFilterBy={userIdToFilterBy} |
Returns a list of Agvance Users. |
PUT AgvanceUser/PutAgvanceUser |
Updates an Agvance User |
AgvanceUserRole
GET AgvanceUserRole/GetAgvanceUserRole |
Returns a list of Agvance User Roles. |
Allocation
GET Allocation/GetAllocations?SalespersonID={SalespersonID}&LocationID={LocationID} |
Returns a list of allocations. |
GET Allocation/GetAllocationsByProduct?DepartmentID={DepartmentID}&ProductID={ProductID}&LocationID={LocationID}&SalespersonID={SalespersonID} |
Returns allocation details for a specific product. |
GET Allocation/GetAllocation?AllocationNumber={AllocationNumber}&LocationID={LocationID}&DeptID={DeptID}&ProdID={ProdID} |
Returns allocation details. |
PUT Allocation/PutAllocation |
Update an allocation. |
POST Allocation/PostAllocation |
Creates an allocation. |
AllocationApproved
GET AllocationApproved/GetAllocationApprovedDetails?AllocationNumber={AllocationNumber}&SalespersonID={SalespersonID}&LocationID={LocationID} |
Returns a allocation/sales order details. |
AllocationOffered
GET AllocationOffered/GetAllocationOfferedDetails?AllocationNumber={AllocationNumber}&SalespersonID={SalespersonID}&LocationID={LocationID} |
Returns a allocation/sales order details. |
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. |
PUT ApBill/PutApBill |
Updates an AP Bill. |
PUT ApBill/VoidApBill |
Voids an AP Bill. |
POST ApBill/ReverseApBill |
Reverses an AP Bill. |
ApDisburse
POST ApDisburse/AchPayment |
Make an ACH payment. |
POST ApDisburse/PrintChecks |
Print an AP disburse check. |
POST ApDisburse/PrintChecksMultiVendor |
Print an AP disburse check. |
POST ApDisburse/Reprint |
Reprint an AP disburse check. |
PUT ApDisburse/ApDisburseVoid |
Void an AP disbursement. |
ApiUser
GET ApiUser/GetApiUsers |
Returns a list of logged on API users for the SessionID. |
POST ApiUser/LogOff |
Logs off all sessions contained in an array of SessionLogKeys submitted in the Request Body |
ApiUserTimeout
GET ApiUserTimeout/GetApiTimeouts |
Returns a list of AgvConn.UniqueID, ApplicationKey, TimeoutMinutes, ApplicationName for all applications. |
PUT ApiUserTimeout/SetTimeouts?UniqueID={UniqueID}&TimeoutMinutes={TimeoutMinutes} |
Updates the TimeoutMinutes for a given connection (AgvConn.UniqueID) |
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 |
POST ApPurchaseOrder/PostApPurchaseOrder |
Creates an AP Purchase Order. |
PUT ApPurchaseOrder/PutApPurchaseOrder |
Updates an AP Purchase Order. |
PUT ApPurchaseOrder/VoidApPurchaseOrder |
Voids an AP Purchase Order. |
PUT ApPurchaseOrder/ProcessApPurchaseOrder |
Updates an AP Purchase Order to processed. |
AttributeType
GET AttributeType/GetAttributeType?attributeType={attributeType} |
Returns a List of Attribute Names for the Requested Type. |
AutoCash
POST AutoCash/PostAutoCashData |
Inserts AutoCash data into the AutoCash tables in Agvance. |
BankDeposit
POST BankDeposit/AddBankDeposit |
Add a Bank Deposit |
POST BankDeposit/ReverseBankDeposit |
Reverse a Bank Deposit |
GET BankDeposit/GetDepositReport?includeDepositTicket={includeDepositTicket}&printLocationOfCheckingAccountProfitCenter={printLocationOfCheckingAccountProfitCenter}&depositGuid={depositGuid}&depositKey={depositKey} |
Gets the requested deposit report |
BidCriteria
GET BidCriteria/GetShipmentBidCriteria?IncludeInactive={IncludeInactive}&AddBlankItem={AddBlankItem} |
Returns a list of Bid Criteria IDs. |
BillSplitArrangement
GET BillSplitArrangement/GetBillSplitArrangement?splitNameSearch={splitNameSearch}&splitNameSearchType={splitNameSearchType} |
Returns a list of Bill Split Arrangements and the departments referenced for each. |
BlendComment
GET BlendComment/GetBlendComment?commentSearch={commentSearch}&commentSearchType={commentSearchType} |
Returns a list of Billing Notes. |
POST BlendComment/PostBlendComment |
Creates a new Blend Billing Note record |
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). |
GET BlendTicket/GetBlendTicketByTicket?Ticket={Ticket} |
Returns a blend ticket by ticket number. |
PUT BlendTicket/PutBlendTicket |
Update a blend ticket. |
PUT BlendTicket/PutBlendTicketReplaceProducts |
Update a blend ticket. Able to Delete and Update all products. |
PUT BlendTicket/DeleteProductFromBlendTicket |
Delete a product from an unloaded Blend Ticket. |
PUT BlendTicket/PutAgSyncBlendStatus |
Updates the AgSync Status on BlendField record(s). |
POST BlendTicket/PostBlendTicket |
Add a blend ticket. |
POST BlendTicket/PostReverseBlendTicket |
Reverses the selected blend ticket |
POST BlendTicket/PostRecalculateBlendPlanProducts |
Calculates the products using Agvance logic for the other Unit of Measures for a product on a Blend or Plan. |
POST BlendTicket/PostCalculateAnalysis |
Calculates the analysis of the supplied products using Agvance logic for recalculation of the products and optionally the rounding and tolerance of the location preference. |
POST BlendTicket/PostFormulateAnalysis |
Calculates the formulation request using Agvance logic returning the calculated product information. |
POST BlendTicket/PostRecalculateOrder |
Recalculates the quantity and products needed to meet the requested value for the order. |
POST BlendTicket/PostFormulateAnalysisFullDetail |
Calculates the formulation request using Agvance logic returning the calculated product information. |
POST BlendTicket/PostRecalculateProductsFullDetail |
Calculates the products using Agvance logic for the other Unit of Measures for a product on a Blend or Plan. |
POST BlendTicket/PostRecalculateOrderFullDetail |
Recalculates the quantity and products needed to meet the requested value for the order. |
POST BlendTicket/PostCalculateAnalysisPrice |
Calculates the quantity, pricing, and products extensions for all products related to an analysis price. |
POST BlendTicket/PostCalculateSaltOutTemperature |
Calculates the salt out temperature. |
BlendTicketDocument
POST BlendTicketDocument/CreateBlendDocuments |
Create blend ticket documents for the requested tickets |
BlendTicketList
GET BlendTicketList/GetBlendTicket?custID={custID}&fieldID={fieldID}&Location={Location}&StartDate={StartDate}&EndDate={EndDate} |
Returns a list of blend tickets. |
BlendTicketValidate
POST BlendTicketValidate/ValidateBlendTicket |
Validate a blend ticket. |
Booking
GET Booking/GetBooking?StartDate={StartDate}&EndDate={EndDate}&lastModifiedOnOrAfterUtc={lastModifiedOnOrAfterUtc}&lastModifiedOnOrBeforeUtc={lastModifiedOnOrBeforeUtc}&custID={custID}&bookGuid={bookGuid}&excludeBookSignature={excludeBookSignature} |
Returns booking data. |
POST Booking/PostBooking |
Creates a new Booking. |
PUT Booking/PutBooking |
Updates a Booking |
GET Booking/GetNewBookingContractDocumentForS3?bookingGuid={bookingGuid}&customerGuid={customerGuid} |
Given a booking unique identifier and customer unique identifier, will generate the legacy contract and save it in S3 giving back the identifier of that file and a presigned url to it |
GET Booking/GetPlannedPaymentMethodList |
Returns a list of the Booking Pay Methods |
POST Booking/PostCalculateExtraCharges |
Looks for extra charges for specified location, customer(s) and product(s) then returns the new product(s) that could be added to a booking. |
ClassificationType
GET ClassificationType/GetClassificationType?classificationType={classificationType} |
Returns a list of Classifications of the requested type. |
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 |
ContainerConstructionMaterial
GET ContainerConstructionMaterial/GetContainerConstructionMaterials |
Returns a list of Container Construction Materials. |
POST ContainerConstructionMaterial/PostContainerConstructionMaterial |
Creates a Container Construction Material. |
ContainerSealMaterial
GET ContainerSealMaterial/GetContainerSealMaterials |
Returns a list of Container Seal Materials. |
POST ContainerSealMaterial/PostContainerSealMaterial |
Creates a Container Seal Material. |
ContainerTankType
GET ContainerTankType/GetContainerTankTypes |
Returns a list of Container Tank Types. |
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. |
POST CreditCheck/PostArCredit |
Updates customer AR balances and credit information. |
CreditStatus
GET CreditStatus/GetCreditStatus?creditStatus={creditStatus} |
Returns credit status details. |
CRMActive
GET CRMActive/GetCRMActive |
Checks if CRM is active. |
CRMJournal
GET CRMJournal/GetCrmJournalEntryList?CustID={CustID}&EntryType={EntryType}&StartDate={StartDate}&EndDate={EndDate} |
Get a listing of CRM journal entries. |
POST CRMJournal/PostCrmJournalEntry |
Create a CRM journal entry. |
PUT CRMJournal/PutCrmJournalEntry |
Update a CRM journal entry. |
GET CRMJournal/GetCrmCommunicationTypeList |
Get a listing of CRM journal communication types. |
CRMJournalAttachment
GET CRMJournalAttachment/GetCrmJournalEntryAttachment?AttachmentKey={AttachmentKey} |
Get CRM journal entry attachment data. |
POST CRMJournalAttachment/PostCrmJournalEntryAttachment |
Add an attachment to a CRM journal entry. |
DELETE CRMJournalAttachment/DeleteCrmJournalEntryAttachment?AttachmentKey={AttachmentKey} |
Delete an attachment from a CRM journal entry. |
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}&LastModifiedAfterDate={LastModifiedAfterDate} |
Returns a list of customer addresses. |
PUT CustomerAddress/PutByHin |
Update a customer bill to / ship to address geocode info |
CustomerAED
POST CustomerAED |
Add a Customer. |
POST CustomerAED/PostCustomer |
Add a Customer. |
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. |
CustomerPermits
POST CustomerPermits/CheckPermits |
Customer permit checking for restricted products. |
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. |
Database
GET Database/GetLastYearDatabaseName |
Gets last year database names. |
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. |
POST DeliveryTicket/PostDeliveryTicketFromSalesOrder |
Creates a new Delivery Ticket from an Approved, Non-Processed Sales Order |
POST DeliveryTicket/PostReverseDeliveryTicket |
Reverses the selected 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. |
DeliveryTicketDocument
GET DeliveryTicketDocument/CreateDeliveryTicketDocuments?uniqueKey={uniqueKey}&createDt={createDt}&createHazMat={createHazMat}&createSds={createSds}&createWps={createWps} |
Creates Delivery Ticket documents and returns the filename of the documents. |
POST DeliveryTicketDocument/CreateDeliveryTicketDocuments |
Creates new delivery ticket documents |
GET DeliveryTicketDocument/GetDeliveryTicketDocument?userID={userID}&fileName={fileName} |
Gets a Delivery Ticket document. |
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. |
DispatchDevice
GET DispatchDevice/GetDispatchDevice?dispatchType={dispatchType} |
Returns a list of Dispatch devices by Dispatch type. |
PUT DispatchDevice/PutDispatchDevice |
Updates a DispatchDevice. |
EdnList
GET EdnList/GetEdns?location={location}&vendorID={vendorID} |
Returns a list of EDNs for a specified Vendor. |
GET EdnList/GetNewEdns?vendorID={vendorID}&location={location}&webServNumber={webServNumber}&webServUrl={webServUrl}&webServKey={webServKey} |
Returns a list of EDNs for a specified Vendor including current EDNs and new EDNs from web service. |
EmailPurchaseContract
GET EmailPurchaseContract/GetPurchaseContractEmailAddresses?custID={custID} |
Returns a an email address for the purchase contract grower. |
EmailSalesOrder
GET EmailSalesOrder/GetEmailAddresses?SalesOrderNumber={SalesOrderNumber} |
Returns a list of email addresses for customers on the sales order. |
GET EmailSalesOrder/EmailSalesOrderPDF?SalesOrderNumber={SalesOrderNumber}&Emails={Emails}&Subject={Subject}&Body={Body}&PrintNetPricingSummary={PrintNetPricingSummary}&PrintZeroQuanityLineItems={PrintZeroQuanityLineItems}&PrintUnitPrice={PrintUnitPrice}&PrintDeptID={PrintDeptID}&PrintProdID={PrintProdID}&PrintListPrices={PrintListPrices}&PrintSalesOrderContract={PrintSalesOrderContract} |
Emails a sales order to a list of email addresses. |
EnergyForceApi
POST EnergyForceApi/PostDataApiCallinEntry |
Creates a Callin entry in the Energy Force database |
Farm
GET Farm/GetFarmData?locationIdOrGuid={locationIdOrGuid}&growerIdorGuid={growerIdorGuid}&activeGrowerFilter={activeGrowerFilter}&farmIdorGuid={farmIdorGuid}&farmKey={farmKey}&lastModifiedOnOrAfterUtc={lastModifiedOnOrAfterUtc}&lastModifiedOnOrBeforeUtc={lastModifiedOnOrBeforeUtc} |
Returns a list of farms. |
POST Farm/PostFarm |
Add an Agvance Farm. |
PUT Farm/PutFarm |
Edit an Agvance Farm. |
GET Farm/GetFarms?CustID={CustID}&FieldList={FieldList} |
Returns a list of farms by CustID (GrowerID) |
GET Farm/GetFarmDetail?GrowerID={GrowerID}&FarmID={FarmID}&FarmGUID={FarmGUID}&FarmKey={FarmKey} |
Returns the detailed information about a single farm. To retrieve a farm, provide one of the following combinations: 1. GrowerID + FarmID 2. FarmGUID 3. FarmKey |
FarmList
GET FarmList/GetFarm?locationIdOrGuid={locationIdOrGuid}&growerIdOrGuid={growerIdOrGuid}&activeGrowerFilter={activeGrowerFilter}&farmIdOrGuid={farmIdOrGuid}&farmKey={farmKey} |
Returns a list of Farms |
Field
FieldHistory
FieldList
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
GET FuturesContract/GetFuturesContractByContractByLocationID?Contract={Contract}&Location={Location} |
Returns a futures contract by contract number and location. |
POST FuturesContract/PostFuturesContract |
Create a futures contract |
PUT FuturesContract/PutFuturesContract |
Updates a futures contract |
DELETE FuturesContract/DeleteFuturesContract?Contract={Contract}&Location={Location} |
Deletes 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 |
PUT FuturesMonth/PutFuturesMonthFull |
Update a futures month |
DELETE FuturesMonth/DeleteFuturesMonth?GRFuturesPriceKey={GRFuturesPriceKey} |
Deletes a futures month |
FuturesMonthHistory
POST FuturesMonthHistory/FuturesMonthHistory |
Creates or updates futures month history records for a specified date from the list of futures month keys sent in |
Geocode
GrainForNonAgvance
POST GrainForNonAgvance/PostGrainDataNonAgvancePrivateRestricted |
Custom for companies that want to use G360 but don't have Agvance Grain (NOT FOR PUBLIC USE EVER) |
GrainReports
POST GrainReports/GetAssemblySheetWithScaleTicketsReport |
Generate an Assembly Sheet With Scale Tickets report |
POST GrainReports/GetDeliveredGrainReport |
Generate a Delivered Grain report |
POST GrainReports/GetGrainBankStatementReport |
Generate a Grain Bank Statement report |
POST GrainReports/GetDprTprReport |
Generate a Combined DPR/TPR Report |
GrowerOrder
GET GrowerOrder/GetGrowerOrder?DeptID={DeptID}&ProdID={ProdID}&GrowerID={GrowerID}&LocationID={LocationID}&GrowerOrderNumber={GrowerOrderNumber} |
Returns a list of grower orders |
HazmatDocument
GET HazmatDocument/GetHazmatDocument?documentType={documentType}&transactionGuid={transactionGuid}&printOneHazmatPerBatch={printOneHazmatPerBatch} |
Returns a list pre-signed urls to pdfs of Hazmat documents for the given transaction |
HelenaLotNumber
PUT HelenaLotNumber/PutHelenaProdLotActiveFlag?locationSubCode={locationSubCode}&productId={productId}&lotNumber={lotNumber}&inactive={inactive} |
Updates the Product Lot Numbers "Active" status based on the supplied parameters |
HelenaOraclePayment
GET HelenaOraclePayment/GetHelenaOraclePendingPayments?paymentState={paymentState} |
Gets the list of pending payments to post into Oracle |
PUT HelenaOraclePayment/UpdateHelenaOraclePendingPayments |
Updates the Pending Payment to the status from Oracle |
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 |
KwiktagImage
KwiktagReservation
GET KwiktagReservation/GetCurrentBarcode |
Returns the current Kwiktag barcode for the logged in user. |
POST KwiktagReservation/CreateKwiktagReservation |
Creates a Kwiktag reservation. |
LegacyProcess
POST LegacyProcess/CreateAutomatedBlenderFileFromBlend |
Creates a Legacy Process record for processing in the local network |
Location
GET Location/GetLocation?IncludeInactive={IncludeInactive} |
Returns a list of locations. |
LpTank
GET LpTank/GetLpTankInfo?CustomerID={CustomerID}&TankNumber={TankNumber}&LpTankGuid={LpTankGuid}&lastModifiedOnOrAfterUtc={lastModifiedOnOrAfterUtc}&customerLocationIdOrGuid={customerLocationIdOrGuid}&tankLocationIdOrGuid={tankLocationIdOrGuid} |
Returns a list of Tanks. One of the parameters must be used. |
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 |
DELETE LpTank/DeleteTank?lpTankGuid={lpTankGuid} |
Delete a Tank The GUID of the Tank to be deleted. |
ManufactureInventory
POST ManufactureInventory/PostManufactureInventory |
Creates a manufacture inventory record. |
Manufacturer
GET Manufacturer/GetManufacturer |
Returns a list of Manufacturers. |
Map
GET Map/GetFieldGuidFromLayerHash?LayerIDHash={LayerIDHash} |
Get the FieldGUID from the LayerIDHash provided |
GET Map/GetColorHtmlCodeFromRedGreenBlue?authKey={authKey}&redGreenBlue={redGreenBlue} |
Converts the ARGB integer value to an HTML string |
MapInterface
Method
GET Method/GetCompanyMethodCount?StartDate={StartDate}&EndDate={EndDate}&CompanySN={CompanySN}&UserID={UserID}&APIKey={APIKey} |
No documentation available. |
POST Method/SetAllMethods |
No documentation available. |
MiscComment
POST MiscComment/PostMiscComment |
Create a Misc Comment |
GET MiscComment/GetMiscComment?Type={Type} |
Returns all Misc Comments for a comment type |
DELETE MiscComment/DeleteMiscComment?UniqueID={UniqueID} |
Deletes a comment. |
MotorFuel
GET MotorFuel/GetMotorFuelSetupInfo |
Gets the motor fuel setup information. |
Obligation
GET Obligation/GetNewObligationDocumentForS3?obligationGuid={obligationGuid} |
Given an obligation unique identifier, will generate the legacy document and save it in S3 giving back the identifier of that file |
GET Obligation/GetNewObligationAmendmentDocumentForS3?obligationGuid={obligationGuid}&amendmentNumber={amendmentNumber} |
Given an obligation unique identifier and an amendment number, will generate the legacy document and save it in S3 giving back the identifier of that file |
POST Obligation/PostObligation |
Creates an Obligation |
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/PostPrepayPayment |
Creates a new Prepay payment on a booking. |
POST Payment/PostBudgetPayment |
Creates a new Budget payment on a memo invoice. |
POST Payment/ReversePayment |
Reverses a Received on Account payment. |
PUT Payment/VoidPayment |
Voids a Received on Account payment. |
PaymentDiscount
POST PaymentDiscount/GetPaymentDiscount |
Calculates payment discount. |
PaymentTerms
GET PaymentTerms/GetPaymentTerm?id={id}&effectiveDate={effectiveDate}&activeDetailLineFilter={activeDetailLineFilter} |
Returns a list of Payment Terms |
GET PaymentTerms/GetPaymentTerm/{id}?effectiveDate={effectiveDate}&activeDetailLineFilter={activeDetailLineFilter} |
Returns a list of Payment Terms |
PhysicalInventory
GET PhysicalInventory/GetPhysicalInventory?UserID={UserID} |
Returns Physical Inventory Count |
PhysicalInventoryDetail
PUT PhysicalInventoryDetail/PutPhysicalInventory |
Adds, Updates, or Deletes Physical Inventory Detail records |
GET PhysicalInventoryDetail/GetPhysicalInventoryProduct?barcode={barcode}&productSearch={productSearch}&productSearchType={productSearchType}&location={location}&barCodeIsHex={barCodeIsHex}&allUserCounts={allUserCounts} |
Returns product information and user counts from Physical Inventory Management by barcode or product name search. |
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}&lastModifiedOnOrAfterUtc={lastModifiedOnOrAfterUtc}&lastModifiedOnOrBeforeUtc={lastModifiedOnOrBeforeUtc} |
Returns a list of field plans. |
POST Plan/PostFieldPlan |
Add a Field Plan. |
PUT Plan/PutFieldPlan |
Edit a Field Plan. |
DELETE Plan/DeleteFieldPlan?fldPlanUniqueID={fldPlanUniqueID} |
Deletes a Field Plan. |
PUT Plan/DeleteLineItems |
Delete Line Items from a Field Plan. |
PlanList
GET PlanList/GetFieldPlan?CustID={CustID}&FieldID={FieldID}&Location={Location}&StartDate={StartDate}&EndDate={EndDate} |
Returns a list of field plans. |
POST PlanList/GetPlanList |
Returns a list of field plans. |
PlanName
GET PlanName/GetPlanName?planNameGuid={planNameGuid}&activeFilter={activeFilter}&planNameSearch={planNameSearch}&planNameSearchType={planNameSearchType} |
Returns PlanName |
POST PlanName/PostPlanName |
Creates a new PlanName record |
PUT PlanName/PutPlanName |
Updates a PlanName record |
PlanType
GET PlanType/GetPlanType?planTypeGuid={planTypeGuid}&activeFilter={activeFilter}&planTypeSearch={planTypeSearch}&planTypeSearchType={planTypeSearchType} |
Returns PlanType |
POST PlanType/PostPlanType |
Creates a new PlanType record |
PUT PlanType/PutPlanType |
Updates a PlanType record |
Preference
GET Preference/GetPreference?PreferenceType={PreferenceType}&LocationID={LocationID} |
Returns preference information. |
GET Preference/GetWebDbSettings?key={key}&whatSetting={whatSetting} |
Returns the Web Database preferences for the setting that is passed in. |
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. |
PUT PriceLevel/PutPriceLevelFormulas |
Applies formulas attached to price levels on a product. |
Product
ProductBarcode
POST ProductBarcode/PostProductBarcode |
Adds an additional barcode to a product. |
GET ProductBarcode/GetProductsFromBarCode?barCode={barCode}&locationIdOrGuidFilter={locationIdOrGuidFilter}&onlySearchInFrozenBalances={onlySearchInFrozenBalances} |
Returns a list of product information for the given barcode |
ProductDeliveryOrder
POST ProductDeliveryOrder/PostProductDeliveryOrder |
Add a Product Delivery Order. |
PUT ProductDeliveryOrder/PutProductDeliveryOrder |
Edit a Product Delivery Order. |
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. |
DELETE ProductQuote/DeleteProductQuote?QuoteNumber={QuoteNumber} |
Delete a product quote. |
ProductReplacementCost
PUT ProductReplacementCost/PutProductReplacementCost |
Updates replacement costs |
ProductSetList
GET ProductSetList/GetProductSetList?LocationFilter={LocationFilter}&ActiveOnly={ActiveOnly} |
Returns a list of Product Sets. |
ProductUse
PurchaseAndSale
POST PurchaseAndSale/PostPurchaseAndSale |
Add a purchase and sale transaction. |
GET PurchaseAndSale/GetPurchaseAndSale?location={location}&transactionNumber={transactionNumber} |
Get a purchase and sale transaction. |
POST PurchaseAndSale/ReversePurchaseAndSale |
Reverse a purchase and sale transaction |
PurchaseContract
PurchaseInvoice
GET PurchaseInvoice/GetPurchaseInvoiceDocument?purchaseInvoiceGuid={purchaseInvoiceGuid} |
Returns the S3 Presigned Url for a Purchase Invoice document |
GET PurchaseInvoice/GetPurchaseInvoice?VendorID={VendorID}&InvoiceNumber={InvoiceNumber} |
Returns a purchase invoice. |
POST PurchaseInvoice/PostPurchaseInvoice |
Creates a new purchase invoice. |
PUT PurchaseInvoice/VoidPurchaseInvoice |
Voids a purchase invoice. |
PurchaseInvoiceList
PurchaseOffer
DELETE PurchaseOffer/DeletePurchaseOfferContract?PurOfferContractGuid={PurOfferContractGuid}&ReasonForChange={ReasonForChange} |
Deletes a purchase offer contract |
POST PurchaseOffer/PostPurchaseOfferContract |
Create a purchase offer contract |
PUT PurchaseOffer/PutPurchaseOfferContract |
Updates a purchase offer contract |
PurchaseOrder
PurchaseReceipt
GET PurchaseReceipt/GetPurchaseReceiptold?VendorID={VendorID}&TicketNumber={TicketNumber} |
Returns purchase receipt |
GET PurchaseReceipt/GetPurchaseReceiptByVendorIDByTicketNumber?VendID={VendID}&TicketNum={TicketNum} |
Returns purchase receipt |
POST PurchaseReceipt/PostPurchaseReceipt |
Creates a new purchase receipt |
PUT PurchaseReceipt/PutPurchaseReceipt |
Updates a purchase receipt |
PurchaseReceiptList
RouteOptimization
POST RouteOptimization/GetRouteOptimization |
Returns a list of destinations in an optimized order. |
SalesContract
GET SalesContract/GetSalesContract?ContractNumber={ContractNumber}&Location={Location}&Commodity={Commodity}&ContractType={ContractType}&ContractStatus={ContractStatus}&ShippingDestination={ShippingDestination}&StartDeliveryDate={StartDeliveryDate}&CompleteDeliveryDate={CompleteDeliveryDate}&BidCriteria={BidCriteria}&FuturesMonth={FuturesMonth} |
Returns a list of sales contracts. |
POST SalesContract/PostSalesContract |
Creates a Sales Contract |
PUT SalesContract/PutSalesContract |
Updates a Sales Contract |
DELETE SalesContract/DeleteSalesContract?salesContractGuid={salesContractGuid} |
Delete a Sales Contract The GUID of the Sales Contract to be deleted. |
POST SalesContract/MigrateSalesContract |
Migrate a Sales Contract |
SalesOrder
GET SalesOrder/GetSalesOrders?CustID={CustID}&Processed={Processed}&Status={Status} |
Returns a list of sales orders for a customer. |
GET SalesOrder/GetSalesOrder?SalesOrderNumber={SalesOrderNumber} |
Returns sales order details for a customer. |
GET SalesOrder/GetNextSalesOrderNumber?Location={Location} |
Returns the next available sales order number. |
POST SalesOrder/PostSalesOrder |
Create a sales order. |
PUT SalesOrder/PutSalesOrder |
Update a sales order. |
DELETE SalesOrder/DeleteSalesOrder?SalesOrderNumber={SalesOrderNumber} |
Delete a sales order. |
SalesOrderCalculateTax
POST SalesOrderCalculateTax/PostCalculateSalesOrderTax |
Calculates the Sales Tax and Adds the line item if possible for the Estimated Tax |
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
SdsDocument
GET SdsDocument/GetSdsDocument?documentType={documentType}&transactionGuid={transactionGuid} |
Returns a dictionary of the product guid and pre-signed url to a pdf for the SDS documents that exist for the products on the given transaction |
Session
GET Session/GetSessions?StartDate={StartDate}&EndDate={EndDate}&CompanySN={CompanySN}&UserID={UserID}&APIKey={APIKey} |
No documentation available. |
SessionCount
GET SessionCount/GetSessionCount?StartDate={StartDate}&EndDate={EndDate}&companySn={companySn}&UserID={UserID}&APIKey={APIKey} |
No documentation available. |
Settlement
SettlementDocument
POST SettlementDocument/GetSettlementContractDocument |
Get a settlement contract document |
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. |
StateCounty
GET StateCounty/GetStateCounty?state={state} |
Returns a list of States and Counties. |
TargetPest
GET TargetPest/GetTargetPest |
Returns a list of Target Pests. |
TaxRate
POST TaxRate/GetTaxRate |
Returns a list of Tax Rates. |
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 |
Term
GET Term/GetTermList |
Returns a list of terms. |
ToDpr
GET ToDpr/GetGrainSettlementToDPR |
Returns a list of ToDPRs. |
Trait
GET Trait/GetTraitList |
Returns a list of traits. |
UnitOfMeasure
GET UnitOfMeasure/GetUnitOfMeasure |
Returns a list of Units of Measure. |
User
POST User/PostUser?CompanySN={CompanySN}&UserID={UserID}&APIKey={APIKey}&UserPassword={UserPassword}&UserEmail={UserEmail} |
Validates user login. |
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. |
POST User/PostWindowsUser?CompanySN={CompanySN}&WindowsLoginID={WindowsLoginID}&WindowsPassword={WindowsPassword}&APIKey={APIKey}&UserEmail={UserEmail} |
Validates windows user login. |
GET User/GetUserTransactionLog?userToFilter={userToFilter}&documentTypeFilter={documentTypeFilter} |
Returns a list of user transaction logs. |
UserCoded
GET UserCoded |
Validates user login. |
GET UserCoded/Login |
Validates user login. |
GET UserCoded/WindowsLogin |
Validates Windows user login. |
GET UserCoded/SkyExchangeCredentials |
Exchanges Sky user credentials for Agvance credentials and logs into Agvance. |
Utility
GET Utility/GetLogData?StartDate={StartDate}&EndDate={EndDate}&CompanySN={CompanySN}&UserID={UserID}&APIKey={APIKey} |
Returns log data. |
GET Utility/GetRestrictedGroups |
Returns the list of restricted groups from the API setup |
GET Utility/GetRestrictedPropertyGroups |
Returns the list of restricted property groups from the API setup |
POST Utility/PostGetAgvanceDatabaseStatistics?userKey={userKey} |
SSI Internal - See FTM |
POST Utility/PostValidateAgvanceConnectionSettings?userKey={userKey} |
SSI Internal - See FTM |
GET Utility/GetDbIdExists?userKey={userKey}&dbId={dbId} |
Used as a validation check for the API that the DBID exists in the API Connections database |
GET Utility/GetHealthCheck?userKey={userKey} |
Used as a health check for the API that it can connect to the API Connections database |
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. |
VendorList
POST VendorList/GetVendorList |
Returns a list of Vendors |
WebServiceList
GET WebServiceList/GetEDNWebService?vendorID={vendorID} |
Returns a list of web service information for a specified Vendor. |
WpsDocument
GET WpsDocument/GetWpsDocument?documentType={documentType}&transactionGuid={transactionGuid} |
Returns a pre-signed url to a pdf of the WPS for the given transaction |