Tuhund - CI List API

API List

• API Introduction
• Authentication Key API
• Server Date and Time
• Embed Image API
• Attachment Download API
• Common lookups API

CRM Integration API

• List of companies with basic details
• Complete details of a company
• List of customers of a branch with basic details
• Register Person
• Register company
• Register address
• Register contact query
• Login ID availability check
• Customer Login API

Delivery / Shipment Order API

• Register Delivery Order
• Delivery Order Tracking API

Expense Claims Integration API

• Register Expense Claim
• Add expense item to claim
• Save and present claim for approval
• Get list of claims with basic details
• Get claim with all details

Sales Module Integration API

• Register Quotation API
• List of Commercial Invoices
• Number of Commercial Invoices
• Register Invoice API

Shopping Cart Integration API

• Price List API
• Create Shopping Cart Order
• Add product to shopping cart
• Update payment details
• Get order in shopping cart
• List of orders in shopping cart

Procurement Module API

• Purchase Order List
• Purchase Order Details

Manufacturing Module API

• Get job order list
• Get job order details
• Bills of material of a Product
• Bill of material

API # : 8021 | API Name : cilist

Get filtered and sort list of commercial invoices / tax invoices.

URL : <domain>/apic/cilist
Methods Allowed : POST
Request Body : JSON Payload

Payload Structure :

Name	Description	Type
search	Search text.	String
sdate	Starting date in DD/MM/YYYY format. For example 01/04/2020 would get all records starting from April 1, 2020	String
fdate	Ending date in DD/MM/YYYY format. For example 31/03/2021 would get all records till from March 31, 2021	String
itemid	Company ID of the customer.	String
show	Status of the invoice	String
ep1	Accounting Status of the invoice P : Posted to books of accounts A : Posted to books of accounts with awaiting IRN Status N : Not Posted to books of accounts yet	String
show3	Record type ID.	String
show4	Currency. Three letter currency code to get records for a specific currency or "NOT-" and three letter currency code to exclude a particular currency. Examples : USD : Get records for only USD NOT-USD : Get records for all currencies except USD	String
show2	Agent ID. ID of the agent for the sale through agents and sub-dealers. ANY : Value to send for getting sales through all agents. This excludes direct sales. NONE : Value to send for getting direct sales. This excludes all sales through agents and sub-dealers.	String
show8	Zone ID. ID of the marketing zone. none : Value to send for getting sales to customers where marketing zone has not been specified.	String
show6	Group ID. ID of the customer group. none : Value to send for getting sales to customers that are not part of any specific group.	String
ep2	ID of the sales person who has made the sale.	String
show7	Type code of the associated record. If required, please check type code for the deployment being integrated with. Type codes are dynamically generated, but can be edited manually. Therefore, it can differ from deployment to deployment.	String
pp	Number of records per page. All the matching records are split in sets similar to pages. This value tells the system how many records have to be grouped under each page. Default value is 100	Integer
page	Page number. Default is 1	Integer
srt	Sort by. Possible values are : CINUMBER : Commercial Invoice number CIDATE : Commercial Invoice Date CREATEDDATE : Date of creation of the record COMPANYID : Company ID COMPANYNAME : Company ID BUYERID : Buyer ID (Customer ID in case of cash sales. Contact person in case of B2B sales) GROSSTOTAL : Gross Total NETTOTAL : Net Total CPONUMBER : Customer's Purchase Order Number CPODATE : Customer's Purchase Order Date COMPANYNUMBER : Company Number STATUS : Current status of the Commercial Invoice	String
order	Sort Order. ASC or DESC	String

Request Headers :

Name	Description
device	A short name of your application. Device is mandatory but any value between 3 and 20 characters is accepted.
Authentication	Authentication code generated for API call.

Sample Payload :

{ "order": "ASC", "show": "ALL", "srt": "CIDATE", "sdate": "01/04/2020", "fdate": "30/04/2020", "itemid": "BSLUqT" }

Sample success response :

{ "totalrecords": 10, "result": 1, "records": [ { "branchid": "ENTERPRISE", "billingaddress": "DKblWy", "accountstatus": 5, "type": 0, "currency": "INR", "amount": 60000, "revision": 0, "deliverystatus": 0, "shipmentterms": "Local Delivery", "sttype": 0, "cinumber": "2021SIPL01MD1329", "taxtype": 5, "products": 1, "stpercent2": 0, "exchange": 1, "stpercent3": 0, "shippingaddress": "T35f9X", "roundoff": 0, "services": 0, "adiscount": 0, "finalstatus": "Awaiting IRN", "status": 36, "nettotal": 70800, "taxpercent": 0, "discount": 0, "othercharges": 0, "ciid": "O1bLm9", "tax": 10800, "taxremarks": "Inter-state Sales", "freight": 0, "tscrate": 0.75, "stpercent": 0, "sstid": "INTERSTATE", "cidate": "04/02/2021", "tcs": 531 }, { "branchid": "ENTERPRISE", "billingaddress": "RWaiUw", "accountstatus": 5, "type": 0, "currency": "INR", "amount": 288000, "revision": 0, "deliverystatus": 0, "shipmentterms": "Local Delivery", "sttype": 0, "cinumber": "2021SIPL01MD1338", "taxtype": 5, "products": 1, "stpercent2": 0, "exchange": 1, "stpercent3": 0, "shippingaddress": "T35f9X", "roundoff": 0, "services": 0, "adiscount": 0, "finalstatus": "Awaiting IRN", "status": 36, "nettotal": 288000, "taxpercent": 0, "discount": 0, "othercharges": 0, "ciid": "PFfv4v", "tax": 0, "taxremarks": "Export", "freight": 0, "tscrate": 0, "stpercent": 0, "sstid": "INTERNATIONAL", "cidate": "17/02/2021", "tcs": 0 }, { "branchid": "ENTERPRISE", "billingaddress": "RWaiUw", "accountstatus": 5, "type": 0, "currency": "INR", "amount": 92082, "revision": 0, "svtid": "null", "deliverystatus": 0, "buyer": "Abhishekappa BR", "shipmentterms": "Local Delivery", "sttype": 0, "cinumber": "RES1002", "taxtype": 5, "products": 3, "stpercent2": 0, "exchange": 1, "cponumber": "456", "stpercent3": 0, "discountgroupid": "null", "shippingaddress": "T35f9X", "roundoff": 0, "services": 1, "adiscount": 0, "finalstatus": "Awaiting IRN", "status": 36, "taxpercent": 0, "nettotal": 92082, "reference": "PI 20-21-EG-1035", "discount": 0, "othercharges": 0, "ciid": "OnRpTm", "tax": 0, "taxremarks": "Export", "freight": 0, "tscrate": 0, "stpercent": 0, "sstid": "INTERNATIONAL", "cidate": "12/02/2021", "cpodate": "12/02/2021", "tcs": 0 }, { "branchid": "ENTERPRISE", "billingaddress": "RWaiUw", "accountstatus": 5, "type": 0, "currency": "INR", "amount": 38000, "revision": 0, "deliverystatus": 0, "shipmentterms": "Local Delivery", "sttype": 0, "cinumber": "2021SIPL01MD1316", "taxtype": 5, "products": 1, "stpercent2": 0, "exchange": 1, "stpercent3": 0, "shippingaddress": "T35f9X", "roundoff": 0, "services": 0, "adiscount": 100, "finalstatus": "Awaiting IRN", "status": 36, "nettotal": 37900, "taxpercent": 0, "discount": 0, "othercharges": 0, "ciid": "LJKgsz", "tax": -100, "taxremarks": "Export", "freight": 0, "tscrate": 0, "stpercent": 0, "sstid": "INTERNATIONAL", "cidate": "06/01/2021", "tcs": 0 }, { "branchid": "ENTERPRISE", "billingaddress": "DKblWy", "accountstatus": 5, "type": 0, "currency": "INR", "amount": 12175282.35, "revision": 1, "deliverystatus": 0, "shipmentterms": "Local Delivery", "sttype": 0, "cinumber": "2021SIPL01MD1330", "taxtype": 5, "products": 1, "stpercent2": 0, "exchange": 1, "stpercent3": 0, "shippingaddress": "T35f9X", "roundoff": -0.20999999344348907, "services": 0, "adiscount": 0, "finalstatus": "Awaiting IRN", "status": 36, "nettotal": 13636316, "taxpercent": 0, "discount": 0, "othercharges": 0, "ciid": "OQ0Cgo", "tax": 1461033.65, "taxremarks": "Inter-state Sales", "freight": 0, "tscrate": 0.75, "stpercent": 0, "sstid": "INTERSTATE", "cidate": "08/02/2021", "tcs": 102272.37 }, { "branchid": "ENTERPRISE", "billingaddress": "RWaiUw", "accountstatus": 5, "type": 0, "currency": "INR", "amount": 144000, "revision": 0, "deliverystatus": 0, "shipmentterms": "Local Delivery", "sttype": 0, "cinumber": "2021SIPL01MD1333", "taxtype": 5, "products": 1, "stpercent2": 0, "exchange": 1, "stpercent3": 0, "shippingaddress": "T35f9X", "roundoff": 0, "services": 0, "adiscount": 0, "finalstatus": "Printed", "status": 50, "nettotal": 144000, "taxpercent": 0, "discount": 0, "othercharges": 0, "ciid": "PAmFdf", "tax": 0, "taxremarks": "Export", "freight": 0, "tscrate": 0, "stpercent": 0, "sstid": "INTERNATIONAL", "cidate": "16/02/2021", "tcs": 0 }, { "branchid": "ENTERPRISE", "irn": "70bff767709f728c133973e5c0126cd9d2fac5d022302e74617c8925bfa25b6a", "billingaddress": "RWRgPy", "accountstatus": 3, "type": 0, "currency": "INR", "amount": 1625.46, "revision": 0, "svtid": "null", "deliverystatus": 0, "shipmentterms": "Local Delivery", "sttype": 0, "cinumber": "2021SIPL01MD1344", "taxtype": 5, "products": 1, "stpercent2": 0, "exchange": 1, "stpercent3": 0, "discountgroupid": "null", "shippingaddress": "T35f9X", "roundoff": -0.03999999910593033, "services": 0, "adiscount": 0, "finalstatus": "Approved with IRN", "status": 40, "taxpercent": 0, "nettotal": 1918, "reference": "PI 20-21-EG-1048", "discount": 0, "othercharges": 0, "ciid": "QKKfc3", "tax": 292.54, "taxremarks": "Inter-state Sales", "freight": 0, "tscrate": 0.75, "stpercent": 0, "sstid": "INTERSTATE", "cidate": "28/02/2021", "cpodate": "28/02/2021", "tcs": 14.39 }, { "branchid": "ENTERPRISE", "irn": "5539476f30e75a7e129567e550098508b83827070b2041dfbcbf68aff576df70", "billingaddress": "T35f9X", "accountstatus": 3, "type": 0, "currency": "INR", "amount": 102000, "revision": 0, "deliverystatus": 2, "buyer": "Abhishekappa BR", "shipmentterms": "POS", "sttype": 1, "cinumber": "2021SIPL01MD1342", "taxtype": 5, "products": 1, "stpercent2": 0, "exchange": 1, "stpercent3": 0, "shippingaddress": "T35f9X", "roundoff": 0, "services": 0, "adiscount": 0, "payment": "Credit Sale", "finalstatus": "Delivery Auto Completed", "status": 49, "taxpercent": 0, "nettotal": 120360, "reference": "105", "discount": 0, "othercharges": 0, "ciid": "l5kIFyzxQ0", "tax": 18360, "freight": 0, "tscrate": 0, "stpercent": 0, "sstid": "INTERSTATE", "cidate": "24/02/2021", "cpodate": "24/02/2021", "tcs": 0 }, { "branchid": "ENTERPRISE", "billingaddress": "RWaiUw", "accountstatus": 5, "type": 0, "currency": "INR", "amount": 726000, "revision": 0, "deliverystatus": 0, "shipmentterms": "Local Delivery", "sttype": 0, "cinumber": "2021SIPL01MD1337", "taxtype": 5, "products": 3, "stpercent2": 0, "exchange": 1, "stpercent3": 0, "shippingaddress": "T35f9X", "roundoff": 0, "services": 0, "adiscount": 0, "finalstatus": "Printed", "status": 50, "nettotal": 726000, "taxpercent": 0, "discount": 0, "othercharges": 0, "ciid": "PBBgSF", "tax": 0, "taxremarks": "Export", "freight": 0, "tscrate": 0, "stpercent": 0, "sstid": "INTERNATIONAL", "cidate": "16/02/2021", "tcs": 0 }, { "branchid": "ENTERPRISE", "billingaddress": "RWaiUw", "accountstatus": 5, "type": 0, "currency": "INR", "amount": 154500, "revision": 0, "deliverystatus": 0, "shipmentterms": "Local Delivery", "sttype": 0, "cinumber": "2021SIPL01MD1336", "taxtype": 5, "products": 3, "stpercent2": 0, "exchange": 1, "stpercent3": 0, "shippingaddress": "T35f9X", "roundoff": 0, "services": 0, "adiscount": 0, "finalstatus": "Printed", "status": 50, "nettotal": 154500, "taxpercent": 0, "discount": 0, "othercharges": 0, "ciid": "PB5jBp", "tax": 0, "taxremarks": "Export", "freight": 0, "tscrate": 0, "stpercent": 0, "sstid": "INTERNATIONAL", "cidate": "16/02/2021", "tcs": 0 } ] }

Sample failure response :