Dotsimpel

Dotsimpel CMS API 1.1

https://api.dotsimpel.nl/login

Method: POST

username, password

Return: token

Body example
      {
        "token": "token"
      }
    
Example
[{"token":eyJhbGciOiJIUzI1NiIsInR5eeeeekpXVCJ9.eyJ1c2VybmFeeeeenJveSIsImV4cCI6MTU4MjYyMDY1OX0.EMTwnke-M5PXV3LEEU2ffvi7pQmGUbWMAj2KeR94"}]

https://api.dotsimpel.nl/getTurnover

Method: POST

token, startDate, endDate (,moment ['invoice' (default) ,'orderDate'], paidOnly ['true' (default),'false'])

Return: result grouped by date and country, default based on invoice date

Body example
          {
            "token": "token",
            "startDate": "2021-09-01",
            "endDate": "2021-09-30",
            "moment": "invoice",
            "paidOnly": "true"
          }
        
Example
          [{"invoiceDate":"2022-08-01","countryName":"Germany","countryIso":"DE","countryIsEu":"1","orderCount":"4","totalPriceInclVat":"1818.090","totalPriceExclVat":"1802.040","totalVatHigh":"16.050","totalVatLow":"0.000","totalVat":"16.050"},
          {"invoiceDate":"2022-08-01","countryName":"Netherlands","countryIso":"NL","countryIsEu":"1","orderCount":"27","totalPriceInclVat":"3024.780","totalPriceExclVat":"2499.830","totalVatHigh":"524.950","totalVatLow":"0.000","totalVat":"524.950"},
          {"invoiceDate":"2022-08-01","countryName":"Belgium","countryIso":"BE","countryIsEu":"1","orderCount":"5","totalPriceInclVat":"573.480","totalPriceExclVat":"554.140","totalVatHigh":"19.340","totalVatLow":"0.000","totalVat":"19.340"}]
        

https://api.dotsimpel.nl/getCredits

Method: POST

token, startDate, endDate

Return: result grouped by date and country, based on create date

Body example
      {
        "token": "token",
        "startDate": "2021-09-01",
        "endDate": "2021-09-30"
      }
    
Example
    [{"date":"2022-09-01","countryName":"Netherlands","countryIso":"NL","countryIsEu":"1","orderCount":"2","totalPrice":"24.53","totalVat":"4.260"},
    {"date":"2022-09-01","countryName":"Belgium","countryIso":"BE","countryIsEu":"1","orderCount":"1","totalPrice":"55.92","totalVat":"9.710"}]
    

https://api.dotsimpel.nl/getOrders

Method: POST

token, startDate (Y-mm-dd), endDate (Y-mm-dd)

Return: result array of orders, between on date range

Body example
      {
        "token": "token",
        "startDate": "2021-09-01",
        "endDate": "2021-09-30"
      }
    
Example
    [{"orderId":"1","countryName":"Germany","countryIso":"DE","countryIsEu":"1","ids":"1","company_id":"1","website_id":"1","id":"1","token":"1","lng_id":"0","customer_id":"1","customer_id_backup":"0","customer_contact_id":"0","block_return":"0","datetime":"2023-10-16 08:43:43","date":"2023-10-16","sent_date":null,"paid":"true","afterPay":"false","cancelled":"false","last_edit":"2023-10-16 22:45:04","invoice_date":"2023-10-16","invoice_printed":null,"invoice_number":"2","status":"sent","track_and_trace":null,"barcode":null,"contact_details":"BIOB bv \nAdministratie","invoice_address":"BIOB BV \ninfo@testbedrijf.nl\n12345678903041748430/\nTest\u00dfe20-22 20-22\n13405 Koln (Germany)","post_address":"BIOP BV\ninfo@testbedrijf.nl\n03041748430\nTeststraat\u00dfe20-22 20-22\n13405 Berlin (Germany)","post_address_name":"Biop bv","post_address_company_name":"Biop BV","post_address_street":"Teststraat","post_address_street_number":"21","post_address_street_number_additive":"","post_address_zip":"9401","post_address_city":"Berlin","post_address_country":"2","post_address_state":null,"balance":"0.00","costPrice":"3.96","totalPrice":"79.420","totalVat":"0.000","totalVatHigh":"0.000","totalVatLow":"0.000","vatNull":"1","creditTotal":null,"creditVat":null,"creditVatHigh":null,"creditVatLow":null,"shipmentCosts":"0.00","shipmentMethod":"sendIt","paymentCosts":"0.00","paymentMethod":"creditCard","couponCosts":"0.00","quotation":"0","prepaid":"0.00","account":null,"account_bic":null,"account_name":"","comment":"","deliveryDate":"direct","deliveryDateText":null,"deliveryType":"0","deliveryDate2":null,"deliveryMoment":null,"customDeliveryDate":null,"postNlPickup":"0","postNlPickupLocation":null,"ip":"79.228.88.108","utm_source":null,"utm_medium":null,"utm_campaign":null,"utm_content":null,"referType":"","refererName":null,"keywords":null,"refererUrl":null,"visitLength":null,"countActions":null,"actionDetails":null,"comments":null,"comments_warehouse":"","release_when_complete":"0","released_automatically":"0","defShipmentCosts":"0.0000","remainingCouponBalanceId":null,"locked":"0","wrongAddress":"0","bol_order_id":null,"reference":null}]
    

https://api.dotsimpel.nl/getOrdersRules

Method: POST

token, orderId(website_id.orders_id)

Return: result array of order rules, from orderId(website_id.orders_id)

Body example
      {
        "token": "token",
        "orderId": "2.3",
      }
    
Example
    [{"id":"1","stock":"false","released":"true","sent":null,"review":null,"packinglist_id":null,"name":"Product naam 0","product_id":"0","page_id":"0","supplier":"0","supplierName":"Leverancier","shipment_id":"4","number":"1","vat":"21","price":"20.0331","costPrice":"1.1200","quotation":"0","comment":null,"procurement_id":null,"defPrice":"2.24","locked":"0","replaced":null,"canceled":null,"discount":"0.00","type":"product"}]
    

https://api.dotsimpel.nl/getCreditOrdersRules

Method: POST

token, date(Y-mm-dd)

Body example
      {
        "token": "token",
        "date" = "2021-09-01",
        "moment" = "created"
      }
    

Return: result array of order credit rules, from date

Example
    [{"id":"249055","name":"Product naam 1","product_id":"1","supplier":"1","supplierName":"Leverancier","number":"1","vat":"21","price":"19.9200","defPrice":"2.10"}]    

https://api.dotsimpel.nl/getAttachmentByOrderRule

Method: POST

token, orderId(website_id.orders_id), orderRules Id

Return: result attachments, from an order rule

Body example
      {
        "token": "token",
        "orderId": "2.3",
        "orderRuleId": "1"
      }
    
Example
    {"content":"VEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZG","mimetype":"application\/pdf"}
    

https://api.dotsimpel.nl/getInvoice

Method: POST

token, orderId(website_id.orders_id)

Return: result invoice pdf, from an order

Body example
      {
        "token": "token",
        "orderId": "2.3",
      }
    
Example
    {"content":"VEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZG","mimetype":"application\/pdf"}
    

https://api.dotsimpel.nl/getCreditInvoice

Method: POST

token, orderId, creditId

Return: resultcredit invoice pdf, from an order and credit id

Body example
      {
        "token": "token",
        "orderId": "2.3",
        "creditId": "1343433"
      }
    
Example
    {"content":"VEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZGZURVNUcGRmVEVTVHBkZlRFU1RwZG","mimetype":"application\/pdf"}
    

https://api.dotsimpel.nl/getCustomer

Method: POST

token, startDate (Y-mm-dd), endDate (Y-mm-dd) (,moment ['invoice' (default) ,'orderDate'])

Return: result array of orders, between on date range

Body example
      {
        "token": "token",
        "startDate": "2021-09-01",
        "endDate": "2021-09-30"
      }
    
Example
    [{"customer_id":"472777","customer_name":"Heinz-Georg Kramm","customer_company_name":"Heino GMBH","countryIso":"DE","last_order_date":"2025-01-26","order_count":"10","total_price_ex_vat_last_year":"4224.66","customer_status":"1"}]