Cienapps - API

Cienapps - API

Accessing Cienapps Data Through APIs

It is possible to access Cienapps data through APIs. This documentation outlines the various available data sources and the operations you can perform. For further information about availability and accessibility, please contact your account or project manager.


Prerequisites

This section outlines the essential requirements for activating and using the APIs.

Module

The API Triggers Activation module must be enabled in your Cienapps. This module allows notifications to be added for data updates triggered by events such as saving a quote, order, or work order.

Node.js Installation

On your server (client server), our team must install Node.js and the latest version of the application. This is the same application used for right-click access to the Cieblink catalog.

API Key

In the general settings, a Cienapps administrator must create an API key with the required permissions. This key must be shared with the partner wishing to use this service.

Important Note: By default, read and write permissions are required. Write access allows notifications to be moved to an archive after being read. See further details in the documentation below.

D

API Routes

This section details the available API routes, their call formats, and how they function.

Call Format

Data is managed in JSON format (GET/POST).

Header

Each header must include the specified API key when making API calls:

"ApiToken": "your_API_key_here"

How It Works

After retrieving data in JSON format, the SyncID field contains the notification ID. Once processed, you must call the /sync/confirm API with an array containing this ID. This removes the notification after it has been read. See the section below for more details.


List of Orders (https://server:port/api/sync/order/list) - GET

This API retrieves the list of orders that have been modified. Below are the available fields along with their details.

Member

Data Type

Example

Information Description

Member

Data Type

Example

Information Description

Order_Number

Integer 4/8 bytes

15000, 745837,...

Order number

Order_DateCreate

String “YYYYMMDD”

“20231101”, “19991231”

Creation date

Order_DateDue

String “YYYYMMDD”

“20231101”, “19991231”

Due date

Order_Step_Desc

String

“PARTIAL INVOICING”

Order step

Order_SalesRep_FullName

String

“EVE BEAUCHEMIN”

Full name of the sales rep

Order_SalesRep_UserName

String

“EBEAUCHEMIN”

Cienapps username of the sales rep

Order_Rep_FullName

String

“JEAN-MARC PAQUIN”

Full name of the representative

Order_Rep_UserName

String

“JPAQUIN”

Cienapps username of the representative

Order_Title

String

“CONDOMINIUM WITH 3 FLOORS”

Order title

Order_Reference_PO

String

“U27 (H3) 22-02756”

Purchase order reference

Order_Reference

String

“KITCHEN 3 PIECES”

General reference

Order_Quotation_Number

Array of Integer

84738, 95837, 95938,...

List of quotation numbers linked to order

Customer_First_Name

String

“JOHN”

Customer first name

Customer_Last_Name

String

“DOE”

Customer last name

Customer_Company_Name

String

“ENTREPRISE MASSON INC”

Company name

Customer_Main_Phone

String

“(418) 555-6666”

Phone number

Customer_Address

String

“999 BEACH BLVD”

Address

Customer_City

String

“MONTREAL”

City

Customer_PostalCode

String “X0X 0X0”

“S0S 2P0”

Postal code

Customer_DateCreate

String Date UTC

"2023-08-07 16:29:54.245"

Customer creation date

Customer_Rep

String

“JEANNE DOE”

Customer representative

Customer_Origin

String

“REPUTATION”

Customer origin

SyncID

Integer

11, 48393,…

 

Exemple

[ {

"Order_Number": 4700,

"Order_DateCreate": "20231103",

"Order_DateDue": "20231106",

"Order_Step_Desc": "04 -INVOICED",

"Order_Reference_PO": null,

"Order_Reference": "ANDREW - CUT OUT SINK HO",

"Order_SalesRep_FullName": "TJ DECARIA",

"Order_SalesRep_UserName": "TJDECARIA",

"Order_Rep_FullName": "WILL DOE",

"Order_Rep_UserName": "WDDOE",

"Order_Title": "ANDREW - CUT OUT SINK HOLE NOV 3, 2023",

"Customer_Last_Name": "ANDREW DOE",

"Customer_First_Name": null,

"Customer_Company_Name": null,

"Customer_Address": "5239 FIND ME",

"Customer_City": "MONTREAL",

"Customer_PostalCode": "V9L 5J2",

"Customer_DateCreate": "2017-11-08 00:00:00.000",

"Customer_Rep": "WILL DOE",

"Customer_Main_Phone": "(250) 111-2222",

"Customer_Origin": "REFERAL FROM CONTRACTOR / DESIGNER",

"SyncID": 11,

"Order_Quotation_Number": [ 6122 ]

} ]

Quotation List (https://server:port/api/sync/quotation/list) – GET

This API allows you to retrieve the list of quotations that have been modified. Below are the available fields with their details.

Member

Data Type

Example

Information Description

Member

Data Type

Example

Information Description

Quotation_Number

Integer 4/8 bytes

15000, 745837,...

Quotation number

Quotation_DateCreate

String “YYYYMMDD”

“20231101”, “19991231”

Creation date

Quotation_DateClose

String “YYYYMMDD”

“20231101”, “19991231”

Closing date

Quotation_DateValidate

String “YYYYMMDD”

“20231101”, “19991231”

Validation date

Quotation_Step_Desc

String

“1-STEP FIRST MEETING”

Quotation step

Quotation_SalesRep_FullName

String

“EVE BEAUCHEMIN”

Full name of the sales rep

Quotation_SalesRep_UserName

String

“EBEAUCHEMIN”

Cienapps username of the sales rep

Quotation_Rep_FullName

String

“JEAN-MARC PAQUIN”

Full name of the representative

Quotation_Rep_UserName

String

“JPAQUIN”

Cienapps username of the representative

Quotation_Title

String

“CONDOMINIUM WITH 3 FLOORS”

Quotation title

Quotation_Reference_PO

String

“AUTUMN 2023”

Purchase order reference

Quotation_Reference

String

“KITCHEN”

Reference

Customer_First_Name

String

“JOHN”

Customer first name

Customer_Last_Name

String

“DOE”

Customer last name

Customer_Company_Name

String

“ENTREPRISE MASSON INC”

Company name

Customer_Main_Phone

String

“(418) 555-6666”

Phone number

Customer_Address

String

“999 BEACH BLVD”

Address

Customer_City

String

“MONTREAL”

City

Customer_PostalCode

String “X0X 0X0”

“S0S 2P0”

Postal code

Customer_DateCreate

String Date UTC

"2023-08-07 16:29:54.245"

Customer creation date

Customer_Rep

String

“JEANNE DOE”

Customer representative

Customer_Origin

String

“REPUTATION”

Customer origin

SyncID

Integer

11, 48393,…

Notification ID

Exemple

[
{
"Quotation_Number": 6139,
"Quotation_DateCreate": "20231110",
"Quotation_DateClose": "20231110",
"Quotation_DateValidate": "20231124",
"Quotation_Reference_PO": null,
"Quotation_Reference": "SUNCRAFT 12345 WOODRUSH",
"Quotation_Step_Desc": "02 - QUOTING STAGE",
"Quotation_SalesRep_FullName": "MARII ALIKI",
"Quotation_SalesRep_UserName": "MALLIKIKI",
"Quotation_Rep_FullName": "VLADISLAV HELLO",
"Quotation_Rep_UserName": "VHELLO",
"Quotation_Title": "SUNCRAFT 12345 WOODRUSH",
"Customer_Last_Name": "SUNKRAFT CHEESE CONSTRUCTION",
"Customer_First_Name": null,
"Customer_Company_Name": null,
"Customer_Address": "PO BOX 9458 ",
"Customer_City": "DUNCAN",
"Customer_PostalCode": "V9L S0S",
"Customer_DateCreate": "2016-03-30 00:00:00.000",
"Customer_Rep": "VLADISLAV HELLO",
"Customer_Main_Phone": "(250) 748-1234",
"Customer_Origin": "CONTRACTOR / MAINTENANCE DEPARTMENT",
"SyncID": 12
}
]

Work Order List (https://server:port/api/sync/workorder/list) – GET

This API allows you to retrieve the list of work orders that have been modified. Below are the available fields with their details.

Member

Data Type

Example

Information Description

Member

Data Type

Example

Information Description

WorkOrder_Number

String

“5610-2”, “748-91”, ...

Work order number

WorkOrder_Order_Number

Integer (4 bytes)

5610, 748

Order linked to the work order

WorkOrder_Step_Desc

String

“03 PROCESSING COMPLETED”

Work order step

WorkOrder_DateDue

String “YYYY-MM-DD”

“20231101”, “19991231”

Due date

WorkOrder_DateDelivery

String “YYYY-MM-DD”

“20231101”, “19991231”

Delivery date

WorkOrder_BackOrder

Boolean

True, False

Presence of BO product on the work order

Customer_First_Name

String

“JOHN”

Customer first name

Customer_Last_Name

String

“DOE”

Customer last name

Customer_Company_Name

String

“ENTREPRISE MASSON INC”

Company name

Customer_Main_Phone

String

“(418) 555-6666”

Phone number

Customer_Address

String

“999 BEACH BLVD”

Address

Customer_City

String

“MONTREAL”

City

Customer_PostalCode

String

“X0X 0X0”, “S0S 2P0”

Postal code

Customer_DateCreate

String (UTC Date)

"2023-08-07 16:29:54.245"