-->

SMARTapi Documentation

Filter, Sorting, Top

FILTER Examples
*You can use filter in all standard GET calls. Add filtertext as querystring in to your URL.

GET specific vendorwith "No." 40000 
&filtertext=No.=CONST(40000)&token={C93F8BC6-FF44-43B7-889A-C82BF26AA78B}
GET vendors in filterrange from "No." 50000 to 60000
&filtertext=No.=filter(50000..60000)&token={C93F8BC6-FF44-43B7-889A-C82BF26AA78B}
GET vendors in specific "Customer Posting Group"
&filtertext=Vendor Posting Group=CONST(DANMARK)&token={C93F8BC6-FF44-43B7-889A-C82BF26AA78B}
Combination of more filtertertexts. GET vendors from a range of "No." and in specific Vendors "Posting Group"
&filtertext=No.=filter(10000..30000),Vendors Posting Group=CONST(DANMARK)&token={C93F8BC6-FF44-43B7-889A-C82BF26AA78B}
Date filter on Posting-date
&filtertext=posting%20date=filter(2019-04-13..2019-05-05)

Sorting Examples
*You can use sorting in all standard GET calls. Add sortingtext as querystring in to your URL.

&sorting=city&order=descending

LIMIT (TOP)Examples
*You can use Limit in all standard GET calls. Add limittext as querystring in to your URL.

GET specific Top 10 vendor 
&limit=10
 
  • Subscribe SMARTapi
  • Retrieve Companyinformation
  • Retrieve Accountingperiod
  • Retrieve ACCOUNTSCHEDULERESULT
  • Retrieve Cash receipt journallist
  • Retrieve Customers
  • Retrieve Vendors
  • Retrieve Sales Orders
  • Retrieve Sales Order Lines
  • Retrieve Items
  • Retrieve Item Stocks
  • Retrieve Item Salesprices
  • Retrieve Jobs
  • Retrieve Jobtask
  • Retrieve Dimensionvalue
  • Retrieve Dimensionsetentry
  • Populate a General Journal
  • Retrive GL entry
  • Retrieve GL Account
  • Customer Ledger Entry
  • Vendor Ledger Entry
  • Create Customers
  • Create Expense file
  • Create Job Journal Line
  • Create Items
  • Create Sales Order
  • Create Sales Order Lines
  • Create Purchase Line
  • Create Purchase
  • Create Vendor
  • Examples: Filter, Sorting, Limit
  • Retrieve Customernumberlist
  • Retrieve General Ledger Setup
  • Retrieve VAT Setup
  • Retrieve Dimension Mandatory
  • Retrieve Purchases Orders
  • Retrieve Purchases Order lines
  • Retrieve Ressource Costprices
  • Retrieve Item Variant
  • Retrieve Sales Credit Memos
  • Retrieve genproduct posting groups
  • Retrieve inventory posting groups
  • Retrieve column layout names
  • Retrieve General journal batch names
  • Retrieve General journal templates
  • Retrieve sales line discount
  • RetrieveGL-CommentSheet
  • Retrieve salesprice
  • Retrieve Ressource
  • Retrieve SALESINVOICEOIOUBL
  • Retrieve RessourcePrice
  • Retrieve WorkType
  • Retrieve Sales Credit Memos PDF