Citrus Lime Cloud POS API

  • Available through intelligence.citruslime.com/BI
  • You need to make a HTTPS call with an Authorization token in the bearer and specify the content type as application/json
  • Where a FromDate & ToDate parameter is accepted, there is the option to pass both, or only one.

Account Types
URL : intelligence.citruslime.com/BI/AccountType.aspx
Data : All data is returned
DBTimeStamp : DBTimeStamp as string
Brand
URL : intelligence.citruslime.com/BI/Brand.aspx
Data : All data is returned
DBTimeStamp : DBTimeStamp as string
Cashier
URL : intelligence.citruslime.com/BI/Cashier.aspx
URL with parameters : intelligence.citruslime.com/BI/Cashier.aspx?FromDate=30/07/2018 15:00&ToDate=01/08/2018 00:01
Data : All data is available between 4am and 6am GMT.
With a datetime parameter, this will return Cashiers updated between those date/times
DBTimeStamp : DBTimeStamp as string
Category
URL : intelligence.citruslime.com/BI/Category.aspx
Data : All data is returned
DBTimeStamp : DBTimeStamp as string
Courier Booking
URL : intelligence.citruslime.com/BI/CourierBooking.aspx?OrderID=1234
Data : This takes an OrderID as a parameter in the URL and returns the individual courier booking for that order. Returns a 404 response if there is no record available.
DBTimeStamp : DBTimeStamp not available
Customer
URL : intelligence.citruslime.com/BI/Customer.aspx
URL with parameters : intelligence.citruslime.com/BI/Customer.aspx?FromDate=30/07/2018 15:00&ToDate=01/08/2018 00:01
Data : All data is available between 4am and 6am GMT.
With a datetime parameter, this will return Customers updated between those date/times
DBTimeStamp : DBTimeStamp as string
Department
URL : intelligence.citruslime.com/BI/Department.aspx
Data : All data is returned
DBTimeStamp : DBTimeStamp as string
Inventory
URL : intelligence.citruslime.com/BI/Inventory.aspx
URL with parameters : intelligence.citruslime.com/BI/Inventory.aspx?FromDate=30/07/2018 15:00&ToDate=01/08/2018 00:01
Data : All data is available between 4am and 6am GMT.
With a datetime parameter, this will return Inventory updated between those date/times
DBTimeStamp : DBTimeStamp not available
Item
URL : intelligence.citruslime.com/BI/Item.aspx
URL with parameters : intelligence.citruslime.com/BI/Item.aspx?FromDate=30/07/2018 15:00&ToDate=01/08/2018 00:01
Data : All data is available between 4am and 6am GMT.
With a datetime parameter, this will return Items updated between those date/times
DBTimeStamp : DBTimeStamp as string
ItemMovementLog
URL : intelligence.citruslime.com/BI/ItemMovementLog.aspx
URL with parameters : intelligence.citruslime.com/BI/ItemMovementLog.aspx?FromDate=30/07/2018 15:00&ToDate=01/08/2018 00:01
Data : All data is available between 4am and 6am GMT.
With a datetime parameter, this will return Item Movement Logs posted between those date/times
DBTimeStamp : DBTimeStamp not available
Orders
URL : intelligence.citruslime.com/BI/Order.aspx
URL with parameters : intelligence.citruslime.com/BI/Order.aspx?FromDate=30/07/2018 15:00&ToDate=01/08/2018 00:01
Data : All data is available between 4am and 6am GMT.
With a datetime parameter, this will return Orders created between those date/times
DBTimeStamp : DBTimeStamp as string
Order Entries
URL : intelligence.citruslime.com/BI/OrderEntry.aspx?OrderID=1234
Data : This takes an OrderID as a parameter in the URL and returns a list of Order Entries for that order.
DBTimeStamp : DBTimeStamp as string
Purchase Orders
URL : intelligence.citruslime.com/BI/PurchaseOrder.aspx
URL with parameters : intelligence.citruslime.com/BI/PurchaseOrder.aspx?FromDate=30/07/2018 15:00&ToDate=01/08/2018 00:01
Data : All data is available between 4am and 6am GMT.
With a datetime parameter, this will return Purchase Orders created between those date/times
DBTimeStamp : DBTimeStamp as string
Purchase Order Entries
URL : intelligence.citruslime.com/BI/PurchaseOrderEntry.aspx?PurchaseOrderID=1234
Data : This takes an PurchaseOrderID as a parameter in the URL and returns a list of Purchase Order Entries for that purchase order.
DBTimeStamp : DBTimeStamp as string
Reason Codes
URL : intelligence.citruslime.com/BI/ReasonCode.aspx
Data : All data is returned
DBTimeStamp : DBTimeStamp as string
Register
URL : intelligence.citruslime.com/BI/Register.aspx
Data : All data is returned
DBTimeStamp : DBTimeStamp as string
SalesRep
URL : intelligence.citruslime.com/BI/SalesRep.aspx
URL with parameters : intelligence.citruslime.com/BI/SalesRep.aspx?FromDate=30/07/2018 15:00&ToDate=01/08/2018 00:01
Data : All data is available between 4am and 6am GMT.
With a datetime parameter, this will return Sales Reps updated between those date/times
DBTimeStamp : DBTimeStamp as string
Season
URL : intelligence.citruslime.com/BI/Season.aspx
Data : All data is returned
DBTimeStamp : DBTimeStamp as string
Store
URL : intelligence.citruslime.com/BI/Store.aspx
Data : All data is returned
DBTimeStamp : DBTimeStamp as string
Supplier
URL : intelligence.citruslime.com/BI/Supplier.aspx
URL with parameters : intelligence.citruslime.com/BI/Supplier.aspx?FromDate=30/07/2018 15:00&ToDate=01/08/2018 00:01
Data : All data is available between 4am and 6am GMT.
With a datetime parameter, this will return Suppliers updated between those date/times
DBTimeStamp : DBTimeStamp as string
Tax
URL : intelligence.citruslime.com/BI/Tax.aspx
Data : All data is returned
DBTimeStamp : DBTimeStamp as string
Tender
URL : intelligence.citruslime.com/BI/Tender.aspx
Data : All data is returned
DBTimeStamp : DBTimeStamp as string
TaxEntry
URL : intelligence.citruslime.com/BI/TaxEntry.aspx
URL with parameters : intelligence.citruslime.com/BI/TaxEntry.aspx?FromDate=30/07/2018 15:00&ToDate=01/08/2018 00:01
Data : All data is available between 4am and 6am GMT.
With a datetime parameter, this will return Tax Entries posted between those date/times
DBTimeStamp : DBTimeStamp as string
TenderEntry
URL : intelligence.citruslime.com/BI/TenderEntry.aspx
URL with parameters : intelligence.citruslime.com/BI/TenderEntry.aspx?FromDate=30/07/2018 15:00&ToDate=01/08/2018 00:01
Data : All data is available between 4am and 6am GMT.
With a datetime parameter, this will return Tender Entries posted between those date/times
DBTimeStamp : DBTimeStamp as string
Transaction
URL : intelligence.citruslime.com/BI/Transaction.aspx
URL with parameters : intelligence.citruslime.com/BI/Transaction.aspx?FromDate=30/07/2018 15:00&ToDate=01/08/2018 00:01
Data : All data is available between 4am and 6am GMT.
With a datetime parameter, this will return Transactions posted between those date/times
DBTimeStamp : DBTimeStamp as string
TransactionEntry
URL : intelligence.citruslime.com/BI/TransactionEntry.aspx
URL with parameters : intelligence.citruslime.com/BI/TransactionEntry.aspx?FromDate=30/07/2018 15:00&ToDate=01/08/2018 00:01
Data : All data is available between 4am and 6am GMT.
With a datetime parameter, this will return Transaction Entries posted between those date/times
DBTimeStamp : DBTimeStamp as string