Report

Reporting information

APIDescription
GET api/Report/ArticleGroupInvoiceDebtorRevenue?StartDate={StartDate}&EndDate={EndDate}

Get revenue report grouped by articlegroup and year, where debtor is the invoice debtor.

GET api/Report/ArticleGroupOrderDebtorRevenue?StartDate={StartDate}&EndDate={EndDate}

Get revenue report grouped by articlegroup and year, where debtor is the order debtor.

GET api/Report/GetOpenBillable

Get open billables, if the current date is higher than duedate the billable is overdue.

GET api/Report/GetOpenClosedRevenue

Get Open and Closed revenue grouped by debtor, both values combined is total revenue of a debtor. For current and last year based on orderdate

Quotation

Quotations

APIDescription
GET api/Quotation/ByCreationDate?CreationDate={CreationDate}&start={start}&limit={limit}

Retrieve list of quotations

GET api/Quotation?ChangeDate={ChangeDate}&start={start}&limit={limit}

Retrieve list of quotations

GET api/Quotation/{id}

Retrieve quotation with link to attached documents

Debtor

Actions for debtors

APIDescription
GET api/Debtor/Extended?limit={limit}&ChangeDate={ChangeDate}&start={start}

Get extended version of cicmpy

GET api/Debtor/FindByFreeField?DebtorFreeField={DebtorFreeField}&searchTerm={searchTerm}

FindByFreeField

POST api/Debtor/{cmp_wwn}/UpdateNote

Updates the Note field for a debtor

GET api/Debtor?limit={limit}&ChangeDate={ChangeDate}&start={start}

GET api/Debtor/{id}?DebtorCode={DebtorCode}&CreditorCode={CreditorCode}&DebtorNumber={DebtorNumber}&CreditorNumber={CreditorNumber}&cmp_code={cmp_code}

Get details of a specific debtor. One of both parameters is manditory.

POST api/Debtor

Creates a debtor or creditor: CustomerType = 'S' for a creditor (supplier). CustomerType = 'C' for a debtor (customer). If debtorcode/creditorcode is empty it will be created automatically.

PUT api/Debtor

Updates a creditor or debtor: CustomerType = 'S' for a creditor (supplier). CustomerType = 'C' for a debtor (customer). Attention: The ID is a manditory field.

Settings

APIDescription
GET api/Settings/ByName?name={name}

Get Application Setting by Name

GET api/Settings

Gets all Application Settings

GET api/Settings/{id}

Get Application Setting by ID

PUT api/Settings/{id}

No documentation available.

POST api/Settings

No documentation available.

Invoice

Invoice information

APIDescription
GET api/Invoice/ByChangeDate?changedate={changedate}&start={start}&limit={limit}

Invoices

GET api/Invoice/ByCreationDate?creationdate={creationdate}&start={start}&limit={limit}

Invoices

GET api/Invoice?DebtorNumber={DebtorNumber}&start={start}&limit={limit}

Invoices

GET api/Invoice/{id}

Details invoice

POST api/Invoice

Create invoice

GeneralLedger

General Ledger Accounts

APIDescription
GET api/GeneralLedger/{AccountNumber}/AccountNumber

No documentation available.

GET api/GeneralLedger?start={start}&limit={limit}&ChangeDate={ChangeDate}

No documentation available.

GET api/GeneralLedger/{id}

No documentation available.

POST api/GeneralLedger

No documentation available.

PUT api/GeneralLedger/{id}

No documentation available.

Synergy

Get And Post actions to Synergy

APIDescription
GET api/Synergy/RequestByNumber?id={id}

Retrieve an request by its RequestNumber

GET api/Synergy/RequestById?id={id}

Retrieve an request by its RequestID

POST api/Synergy

Post a request to Synergy. Also acts as update if you add an existing RequestID to the model.

Stock

Stock positions

APIDescription
POST api/Stock/StockCount

Stock count of an Item

GET api/Stock/CurrentStock?Itemcode={Itemcode}&Warehouse={Warehouse}&start={start}&limit={limit}&Peildatum={Peildatum}

Stock count of an Item

GET api/Stock?ChangeDate={ChangeDate}&start={start}&limit={limit}&warehouse={warehouse}

List of stock postions

GET api/Stock/{id}?warehouse={warehouse}

Stock postions of an Item

InvoiceStatus

Invoice status requests

APIDescription
GET api/InvoiceStatus/Changes?ChangeDate={ChangeDate}

Get invoicenumbers and their respective last change date

GET api/InvoiceStatus?DebtorNumber={DebtorNumber}&InvoiceNumber={InvoiceNumber}&start={start}&limit={limit}

List of invoice statuses

GET api/InvoiceStatus/{id}

Invoice status

PriceList

Price lists

APIDescription
GET api/PriceList/price?itemcode={itemcode}&debnr={debnr}&quantity={quantity}&polldate={polldate}

No documentation available.

GET api/PriceList/dump?debnr={debnr}&polldate={polldate}

No documentation available.

GET api/PriceList/staffels?ItemCode={ItemCode}&debnr={debnr}&PriceList={PriceList}&polldate={polldate}

No documentation available.

GET api/PriceList?ChangeDate={ChangeDate}&start={start}&limit={limit}&ListName={ListName}&ItemCode={ItemCode}&DebiteurNr={DebiteurNr}&CrediteurNr={CrediteurNr}

List of pricelist lines (when requesting a specific price using a "DebiteurNr" you will recieve no results if there are no specific price rules for that debtor)

FinancialEntry

Api Calls for Retrieving Financial information from Exact Globe

APIDescription
GET api/FinancialEntry/ByFaktuurnr?id={id}

Retrieve financial entry

GET api/FinancialEntry/InvoiceStatus?DebtorNumber={DebtorNumber}&InvoiceNumber={InvoiceNumber}

Get Status of an invoice

GET api/FinancialEntry?DagBoek={DagBoek}&ChangeDate={ChangeDate}&ReportingDate={ReportingDate}&start={start}&limit={limit}&withBankAccOnly={withBankAccOnly}

get Financial Entries for a DagBoek (and since changeDate (Inclusive))

GET api/FinancialEntry/{id}

Retrieve financial entry

POST api/FinancialEntry

Create financial entry

Items

Maintain items

APIDescription
GET api/Items/FindByFreeField?FreeField={FreeField}&searchTerm={searchTerm}

FindByFreeField

GET api/Items/ByID?id={id}

Gets a full single article by database ID

POST api/Items/{itemcode}/UpdateImage

Update the image of an item

GET api/Items?IsAssembled={IsAssembled}&start={start}&limit={limit}&ChangeDate={ChangeDate}&StatusAll={StatusAll}

Get a set of items matching the requested parameters

GET api/Items/{id}

Gets a full single article

POST api/Items

Create an item

PUT api/Items

Updates an item

Account

CRUD actions for Exact Globe Accounts. (Do not use, still WIP!!)

APIDescription
POST api/Account/{cmp_wwn}/UpdateNote

Update the Account note field.

GET api/Account?start={start}&limit={limit}&ChangeDate={ChangeDate}

No documentation available.

GET api/Account?cmp_wwn={cmp_wwn}&cmp_code={cmp_code}&debnr={debnr}&crdnr={crdnr}

No documentation available.

POST api/Account

No documentation available.

SalesOrder

Verkooporders (secundaire methodes)

APIDescription
GET api/SalesOrder/ByCreationDate?CreationDate={CreationDate}&start={start}&limit={limit}&DebtorCode={DebtorCode}&cmp_wwn={cmp_wwn}

Verkooporders ophalen

GET api/SalesOrder/{id}/deliver?processDate={processDate}

Deliver a Salesorder

GET api/SalesOrder/{id}/authorize

Fiatteren van een verkooporder.

GET api/SalesOrder/{id}/unauthorize

Defiatteren van een verkooporder.

POST api/SalesOrder/Full

Create a salesorder from a Full Exact SalesOrder model

PUT api/SalesOrder/Full

update a salesorder from a Full Exact SalesOrder model

GET api/SalesOrder/GetFull?SalesOrderNumber={SalesOrderNumber}&action={action}

Details verkooporder

GET api/SalesOrder?ChangeDate={ChangeDate}&start={start}&limit={limit}&DebtorCode={DebtorCode}&cmp_wwn={cmp_wwn}&includeOrderLines={includeOrderLines}

Verkooporders ophalen

GET api/SalesOrder/{id}

Details verkooporder

POST api/SalesOrder

Aanmaken van een verkooporder, wanneer DebNr niet gevuld is moet een OrderDebtor object worden meegegeven, vanuit deze wordt een nieuwe debiteur aangemaakt en word het debiteur nummer in de aangemaakte verkooporder gevuld.

PUT api/SalesOrder?addOnly={addOnly}

Aanmaken van een verkooporder, wanneer DebNr niet gevuld is moet een OrderDebtor object worden meegegeven, vanuit deze wordt een nieuwe debiteur aangemaakt en word het debiteur nummer in de aangemaakte verkooporder gevuld.

OAuth

Retrieve existing OAuth credentials (Beta)

APIDescription
GET api/OAuth/ByType/{type}

No documentation available.

GET api/OAuth/id/{id}

No documentation available.

GET api/OAuth/ClientId/{client_id}

No documentation available.

PUT api/OAuth/Update/id/{id}

No documentation available.

PUT api/OAuth/Update/ClientId/{clientid}

No documentation available.

GET api/OAuth?start={start}&limit={limit}

No documentation available.

HourEntry

APIDescription
POST api/HourEntry

Create an HourEntryLine

Address

Changing and retrieving Contactperson addresses

APIDescription
GET api/Address/{id}

Gets an Address by its GUID Id

GET api/Address?cmp_wwn={cmp_wwn}&ContactId={ContactId}

Gets a list of addresses (one of the parameters must be given)

POST api/Address

Create an address

PUT api/Address/{id}

Update an address

HumRes

APIDescription
GET api/HumRes/{id}

No documentation available.

GET api/HumRes?start={start}&limit={limit}&ChangeDate={ChangeDate}

No documentation available.

Contact

APIDescription
GET api/Contact?start={start}&limit={limit}&ChangeDate={ChangeDate}

Get all contacts

GET api/Contact?RelationID={RelationID}&ChangeDate={ChangeDate}

List of contact persons for a relation

GET api/Contact/{id}

Details of a contact person

POST api/Contact

Create a contact person

PUT api/Contact

Updating a contact person

CQ

APIDescription
POST api/CQ

No documentation available.

Project

Get/Update/Create Projects

APIDescription
GET api/Project?start={start}&limit={limit}&ChangeDate={ChangeDate}

Get All Projects

GET api/Project?ProjectNR={ProjectNR}&CostAndRevenue={CostAndRevenue}

Get specific project based on projectnr

POST api/Project

Create Project

PUT api/Project

Update existing Project

Ledger

Ledger Information

APIDescription
GET api/Ledger?ReportDate={ReportDate}

Retruns the Balance of all General Ledgers

GET api/Ledger?GLAccount={GLAccount}&ReportDate={ReportDate}

No documentation available.

ItemAccount

APIDescription
GET api/ItemAccount?limit={limit}&ChangeDate={ChangeDate}&start={start}

No documentation available.

GET api/ItemAccount/{id}

No documentation available.

POST api/ItemAccount

No documentation available.

PUT api/ItemAccount

No documentation available.

Production

Get Production information and associated order.

APIDescription
GET api/Production?StartDate={StartDate}&EndDate={EndDate}

Get Production data.

GbkMut

Get Ledger Mutations

APIDescription
GET api/GbkMut?DagBoek={DagBoek}&ChangeDate={ChangeDate}

Get GBKMut Entry based on DagBoek

GET api/GbkMut?EntryNumber={EntryNumber}

Get Ledger Mutations

LocalizedValues

Localized values controller.

APIDescription
GET api/LocalizedValues

Gets values

GET api/LocalizedValues/{id}

Gets a value

POST api/LocalizedValues

Sets a value

PUT api/LocalizedValues/{id}

Updates a value

DELETE api/LocalizedValues/{id}

Deletes a value

PurchaseOrder

Purchase orders (secundaire methodes)

APIDescription
GET api/PurchaseOrder?CreditorNumber={CreditorNumber}&Ordernumber={Ordernumber}&start={start}&limit={limit}&changedate={changedate}&includeOrderLines={includeOrderLines}

PurchaseOrders

GET api/PurchaseOrder?Ordernumber={Ordernumber}

PurchaseOrder

POST api/PurchaseOrder

Create PurchaseOrder

PUT api/PurchaseOrder?addOnly={addOnly}&instructionOnly={instructionOnly}

update purchaseorder

Resource

APIDescription
GET api/Resource/{ID}?UserID={UserID}&ChangeDate={ChangeDate}

Gets a resource

POST api/Resource

Create resource

PUT api/Resource

Update resource

Attachments

APIDescription
GET api/DocumentLink/{id}

Retrieve the complete document

MandateAccount

APIDescription
GET api/MandateAccount?DebtorNumber={DebtorNumber}

Mandates of a debtor

GET api/MandateAccount/{id}

Mandates of a debtor

POST api/MandateAccount

Creates an mandate: SortOfMandate = 'C' for Core. SortOfMandate = 'B' for B2B. SortOfMandate = 'R' for COR1. SequenceType = 'F' for first. SequenceType = 'R' for recurring. SequenceType = 'L' for last. SequenceType = 'O' for once. Status = 'A' for active. Status = 'B' for blocked. Status = 'D' for concept. Status = 'E' for void.

PUT api/MandateAccount

No documentation available.

BankAccount

Bankrekening Informatie

APIDescription
GET api/BankAccount?DebtorNumber={DebtorNumber}&CreditorNumber={CreditorNumber}

Bankaccount of debtor or Creditor

GET api/BankAccount/{id}

Bank account Details

POST api/BankAccount

Create bank account

PUT api/BankAccount

Updating a bank account