Report
Reporting information
API | Description |
---|---|
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
API | Description |
---|---|
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
API | Description |
---|---|
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
API | Description |
---|---|
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
API | Description |
---|---|
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
API | Description |
---|---|
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
API | Description |
---|---|
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
API | Description |
---|---|
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
API | Description |
---|---|
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
API | Description |
---|---|
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
API | Description |
---|---|
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
API | Description |
---|---|
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!!)
API | Description |
---|---|
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)
API | Description |
---|---|
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)
API | Description |
---|---|
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
API | Description |
---|---|
POST api/HourEntry |
Create an HourEntryLine |
Address
Changing and retrieving Contactperson addresses
API | Description |
---|---|
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
API | Description |
---|---|
GET api/HumRes/{id} |
No documentation available. |
GET api/HumRes?start={start}&limit={limit}&ChangeDate={ChangeDate} |
No documentation available. |
Contact
API | Description |
---|---|
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
API | Description |
---|---|
POST api/CQ |
No documentation available. |
Project
Get/Update/Create Projects
API | Description |
---|---|
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
API | Description |
---|---|
GET api/Ledger?ReportDate={ReportDate} |
Retruns the Balance of all General Ledgers |
GET api/Ledger?GLAccount={GLAccount}&ReportDate={ReportDate} |
No documentation available. |
ItemAccount
API | Description |
---|---|
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.
API | Description |
---|---|
GET api/Production?StartDate={StartDate}&EndDate={EndDate} |
Get Production data. |
GbkMut
Get Ledger Mutations
API | Description |
---|---|
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.
API | Description |
---|---|
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)
API | Description |
---|---|
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
API | Description |
---|---|
GET api/Resource/{ID}?UserID={UserID}&ChangeDate={ChangeDate} |
Gets a resource |
POST api/Resource |
Create resource |
PUT api/Resource |
Update resource |
DocumentLink
Attachments
API | Description |
---|---|
GET api/DocumentLink/{id} |
Retrieve the complete document |
MandateAccount
API | Description |
---|---|
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
API | Description |
---|---|
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 |