Sage Intacct Component
Use the Sage Intacct component to manage Invoices, Payments, Vendors, and more.
Component key: sage-intacctDescription
Sage Intacct is an industry-leading financial accounting software system with a broad set of functionalities for businesses across a number of different verticals.
Use the Sage Intacct component to manage Invoices, Payments, Vendors, and more.
API Reference: Sage Intacct API Reference
Connections
Sage Intacct Connection
Web Service Authentication
- Web Services credentials consist of a sender ID and password. These are provisioned by Sage Intacct for customers/partners with an active Web Services developer license.
- Company credentials consist of either:
- A company ID, user ID, and password - this is called login authentication.
- A temporary session ID - this is called session authentication.
- To Authenticate through Sage Intacct you must establish an API session that provides you with a session ID. The session timeout is calculated based on the session duration specified for the user or company plus the current time.
Actions
Create Bill
Create a new bill. | key: createBill
Output Example Payload
{
"data": {
"response": {
"control": [
{
"status": [
"success"
],
"senderid": [
"testgroup"
],
"controlid": [
"1704925436123"
],
"uniqueid": [
"false"
],
"dtdversion": [
"3.0"
]
}
],
"operation": [
{
"authentication": [
{
"status": [
"success"
],
"userid": [
"TestUser"
],
"companyid": [
"testgroup-imp"
],
"locationid": [
"firstchoice"
],
"sessiontimestamp": [
"2024-01-10T22:23:57+00:00"
],
"sessiontimeout": [
"2024-01-11T06:23:57+00:00"
]
}
],
"result": [
{
"status": [
"success"
],
"function": [
"create"
],
"controlid": [
"49143589-7eff-4a44-a049-378ed812345"
],
"data": [
{
"$": {
"listtype": "objects",
"count": "1"
},
"apbill": [
{
"RECORDNO": [
"4760"
]
}
]
}
]
}
]
}
]
}
}
}
Create Contact
Creates a new contact. | key: createContact
Output Example Payload
{
"data": {
"_status": "success",
"_functionName": "create",
"_controlId": "b8ff1fd1-10ac-4a3c-aa5b-2cf8494f1234",
"_listType": "objects",
"_count": 1,
"_data": [
{
"RECORDNO": "19713",
"CONTACTNAME": "John Doe"
}
]
}
}
Create Customer
Creates a customer and specifies a display contact and a contact list (provided via customer contacts). | key: createCustomer
Output Example Payload
{
"data": {
"_status": "success",
"_functionName": "create",
"_controlId": "8245cb67-8fd6-4785-9008-121acd2d1234",
"_listType": "objects",
"_count": 1,
"_data": [
{
"RECORDNO": "12499",
"CUSTOMERID": "C-01564"
}
]
}
}
Create Invoice
Creates an invoice. | key: createInvoice
Output Example Payload
{
"data": {
"response": {
"control": [
{
"status": [
"success"
],
"senderid": [
"example"
],
"controlid": [
"1705003571234"
],
"uniqueid": [
"false"
],
"dtdversion": [
"3.0"
]
}
],
"operation": [
{
"authentication": [
{
"status": [
"success"
],
"userid": [
"UtilizeCore"
],
"companyid": [
"example-imp"
],
"locationid": [
"example-location"
],
"sessiontimestamp": [
"2024-01-11T20:06:13+00:00"
],
"sessiontimeout": [
"2024-01-12T04:06:13+00:00"
]
}
],
"result": [
{
"status": [
"success"
],
"function": [
"create_invoice"
],
"controlid": [
"3a7463e3-d65e-4056-be1a-158f2cf51234"
],
"key": [
"4774"
]
}
]
}
]
}
}
}
Create Vendor
Creates a new vendor. | key: createVendor
Output Example Payload
{
"data": {
"_status": "success",
"_functionName": "create",
"_controlId": "a30ea5c6-565b-4c31-95a7-b503fe071234",
"_listType": "objects",
"_count": 1,
"_data": [
{
"RECORDNO": "1234",
"VENDORID": "V-12345"
}
]
}
}
Get AP Payment
Retrieve a single AP Payment. | key: getApPayment
Output Example Payload
{
"data": {
"_status": "success",
"_functionName": "read",
"_controlId": "dff0b3b1-af3f-4e52-9260-917ab4f61234",
"_listType": "APPYMT",
"_count": 0,
"_data": []
}
}
Get AR Payment
Retrieve a single AR Payment. | key: getArPayment
Output Example Payload
{
"data": {
"_status": "success",
"_functionName": "read",
"_controlId": "9f54dc6e-ddcc-43ed-a979-eed3599b1234",
"_listType": "ARPYMT",
"_count": 0,
"_data": []
}
}
Get Bill
Retrieve a single bill. | key: getBill
Output Example Payload
{
"data": {
"_status": "success",
"_functionName": "read",
"_controlId": "9b7a9dc1-be4a-471a-95a6-6e8e68dc1234",
"_listType": "APBILL",
"_count": 1,
"_data": [
{
"RECORDNO": "2746",
"RECORDTYPE": "pi",
"RECORDID": "11111",
"CONTACTTAXGROUP": "",
"FINANCIALENTITY": "",
"STATE": "Posted",
"RAWSTATE": "A",
"VENDORID": "V-01234",
"VENDORNAME": "Changed Name",
"VENDORKEY": "1234",
"FORM1099TYPE": "",
"FORM1099BOX": "",
"VENDTYPE1099TYPE": "",
"TRX_ENTITYDUE": "1902.28",
"DOCNUMBER": "",
"DESCRIPTION": "",
"DESCRIPTION2": "",
"TERMNAME": "",
"TERMKEY": "",
"TERMVALUE": "",
"WHENCREATED": "2023-12-06",
"WHENPOSTED": "2023-12-06",
"WHENDISCOUNT": "",
"WHENDUE": "2023-12-06",
"WHENPAID": "",
"RECPAYMENTDATE": "",
"PAYMENTPRIORITY": "normal",
"ONHOLD": "false",
"BASECURR": "USD",
"CURRENCY": "USD",
"EXCH_RATE_DATE": "",
"EXCH_RATE_TYPE_ID": "",
"EXCHANGE_RATE": "",
"TOTALENTERED": "100.12",
"TOTALSELECTED": "0",
"TOTALPAID": "0",
"TOTALDUE": "100.12",
"TRX_TOTALENTERED": "100.12",
"TRX_TOTALSELECTED": "0",
"TRX_TOTALPAID": "0",
"TRX_TOTALDUE": "100.12",
"BILLTOPAYTOCONTACTNAME": "A vendor(VV-01234)",
"SHIPTORETURNTOCONTACTNAME": "A vendor(VV-01234)",
"BILLTOPAYTOKEY": "22135",
"SHIPTORETURNTOKEY": "22135",
"PRBATCH": "Bills - locationId: 2024/01/02 13:26:29:633 Batch",
"PRBATCHKEY": "2092",
"MODULEKEY": "3.AP",
"DOCUMENT_DOCPARID": "",
"SCHOPKEY": "",
"SYSTEMGENERATED": "F",
"AUWHENCREATED": "2024-01-02T18:26:29Z",
"WHENMODIFIED": "2024-01-02T18:37:32Z",
"CREATEDBY": "43",
"MODIFIEDBY": "43",
"DUE_IN_DAYS": "36",
"PAYTO": {
"TAXGROUP": {
"NAME": "",
"RECORDNO": ""
},
"TAXID": ""
},
"INCLUSIVETAX": "false",
"TAXSOLUTIONKEY": "",
"TAXSOLUTIONID": "",
"SHOWMULTILINETAX": "",
"TAXMETHOD": "",
"RETAINAGEPERCENTAGE": "",
"TRX_TOTALRETAINED": "0",
"TRX_TOTALRELEASED": "0",
"TOTALRETAINED": "0",
"SUPDOCID": "",
"SUPDOCKEY": "",
"BILLBACKTEMPLATE": "",
"USERID": "TestUser",
"CREATEDUSERID": "TestUser",
"DOCSOURCE": "",
"UPLOADSTATUS": "",
"RECIPIENTEMAIL": "",
"SENDEREMAIL": "",
"RETAINAGERELEASED": "false",
"MEGAENTITYKEY": "36",
"MEGAENTITYID": "locationId",
"MEGAENTITYNAME": "Location Name",
"BDC_BILLID": "",
"BDC_ORGID": "",
"BDC_URL_PREFIX": "",
"BUILDOPSUPDATE": "false",
"BO_REC": "",
"EXTERNALURL": "",
"EXCHRATEDATE": "",
"EXCHRATETYPE": "",
"EXCHRATE": "",
"PAYTOCONTACTNAME": "A vendor(VV-01234)",
"RETURNTOCONTACTNAME": "A vendor(VV-01234)",
"APBILLITEMS": {
"apbillitem": {
"RECORDNO": "12996",
"RECORDKEY": "2746",
"ACCOUNTKEY": "261",
"ACCOUNTNO": "10000",
"OFFSETACCOUNTKEY": "65",
"OFFSETGLACCOUNTNO": "20000",
"OFFSETGLACCOUNTTITLE": "Accounts Payable",
"ACCOUNTTITLE": "Account",
"ACCOUNTLABELKEY": "",
"ACCOUNTLABEL": "",
"PRENTRYOFFSETACCOUNTKEY": "65",
"PRENTRYOFFSETACCOUNTNO": "20000",
"ENTRY_DATE": "2023-12-06",
"AMOUNT": "100.12",
"TRX_AMOUNT": "100.12",
"DEPT": "",
"DEPARTMENTID": "",
"DEPARTMENTNAME": "",
"LOCATION": "36",
"LOCATIONID": "locationId",
"LOCATIONNAME": "Location Name",
"ENTRYDESCRIPTION": "Line 1 of my bill",
"EXCH_RATE_DATE": "",
"EXCH_RATE_TYPE_ID": "",
"EXCHANGE_RATE": "1",
"ALLOCATION": "",
"ALLOCATIONKEY": "",
"FORM1099": "false",
"LINEITEM": "T",
"LINE_NO": "1",
"CURRENCY": "USD",
"BASECURR": "USD",
"TOTALPAID": "0",
"TRX_TOTALPAID": "0",
"TOTALSELECTED": "0",
"TRX_TOTALSELECTED": "0",
"BILLABLE": "false",
"BILLED": "false",
"RELEASETOPAY": "false",
"PARENTENTRY": "",
"BASELOCATION": "36",
"STATE": "A",
"RECORDTYPE": "pi",
"FORM1099TYPE": "",
"FORM1099BOX": "",
"DETAILID": "",
"ISTAX": "false",
"DETAILKEY": "",
"WHENCREATED": "2024-01-02T18:26:29Z",
"WHENMODIFIED": "2024-01-02T18:37:32Z",
"CREATEDBY": "43",
"MODIFIEDBY": "43",
"TAXRATE": "",
"RETAINAGEPERCENTAGE": "",
"TRX_AMOUNTRETAINED": "",
"AMOUNTRETAINED": "",
"HASRETAINAGE": "false",
"TRX_AMOUNTRELEASED": "",
"RETAINAGERELEASED": "false",
"RETAINAGE_OFFSETACCOUNTKEY": "",
"RETAINAGE_OFFSETGLACCOUNTNO": "",
"RETAINAGE_OFFSETGLACCOUNTTITLE": "",
"SUBTOTAL": "",
"PARENTTAXENTRY": "",
"PARTIALEXEMPT": "false",
"PAYMENTTAXCAPTURE": "false",
"GLOFFSET": "1",
"RECORDID": "11111",
"NAMEOFACQUIREDASSET": "",
"INCLUDETAXINASSETCOST": "false",
"ITEM_DESC": "",
"DESCRIPTION": "",
"JOB": "",
"BUILDOPSLINK": "",
"GLDIMDIVISION": "10030",
"PROJECTDIMKEY": "",
"PROJECTID": "",
"PROJECTNAME": "",
"CUSTOMERDIMKEY": "",
"CUSTOMERID": "",
"CUSTOMERNAME": "",
"VENDORDIMKEY": "",
"VENDORID": "",
"VENDORNAME": "",
"EMPLOYEEDIMKEY": "",
"EMPLOYEEID": "",
"EMPLOYEENAME": "",
"ITEMDIMKEY": "",
"ITEMID": "",
"ITEMNAME": "",
"CLASSDIMKEY": "",
"CLASSID": "",
"CLASSNAME": "",
"RGLDIM101000000010217_10067": "10030",
"GLACCOUNTNO": "10000",
"GLACCOUNTTITLE": "Account",
"ENTRYEXCHRATEDATE": "",
"ENTRYEXCHRATETYPE": "",
"ENTRYEXCHRATE": "1",
"ENTRYCURRENCY": "USD",
"ENTRYBASECURRENCY": "USD"
}
},
"VENDOR": "V-01234--Changed Name"
}
]
}
}
Get Contact
Retrieve a single contact. | key: getContact
Output Example Payload
{
"data": {
"_status": "success",
"_functionName": "read",
"_controlId": "b53e1bee-6ab4-4ba5-955d-731ffcb51234",
"_listType": "CONTACT",
"_count": 1,
"_data": [
{
"RECORDNO": "12345",
"VERSIONKEY": "22115",
"CONTACTNAME": "A Contact Name Two",
"COMPANYNAME": "",
"PREFIX": "",
"FIRSTNAME": "",
"LASTNAME": "",
"INITIAL": "",
"PRINTAS": "Testing",
"TAXABLE": "false",
"TAXGROUP": "",
"PHONE1": "",
"PHONE2": "",
"CELLPHONE": "",
"PAGER": "",
"FAX": "",
"EMAIL1": "",
"EMAIL2": "",
"URL1": "",
"URL2": "",
"VISIBLE": "true",
"MAILADDRESS": {
"ADDRESS1": "",
"ADDRESS2": "",
"ADDRESS3": "",
"CITY": "",
"STATE": "",
"ZIP": "",
"COUNTRY": "United States",
"COUNTRYCODE": "US",
"LATITUDE": "",
"LONGITUDE": ""
},
"STATUS": "active",
"PRICESCHEDULE": "",
"DISCOUNT": "",
"PRICELIST": "",
"PRICELISTKEY": "",
"TAXID": "",
"SIRET": "",
"TAXGROUPKEY": "",
"TAXSOLUTIONKEY": "",
"TAXSOLUTIONID": "",
"TAXSCHEDULE": "",
"PRICESCHEDULEKEY": "",
"WHENCREATED": "2023-12-04T01:35:30Z",
"WHENMODIFIED": "2023-12-04T01:35:30Z",
"CREATEDBY": "43",
"MODIFIEDBY": "43",
"MEGAENTITYKEY": "",
"MEGAENTITYID": "",
"MEGAENTITYNAME": ""
}
]
}
}
Get Customer
Retrieve a single customer. | key: getCustomer
Output Example Payload
{
"data": {
"_status": "success",
"_functionName": "read",
"_controlId": "37882748-090a-4131-a6f3-d411d9c22556",
"_listType": "CUSTOMER",
"_count": 1,
"_data": [
{
"RECORDNO": "12499",
"CUSTOMERID": "C-01234",
"NAME": "John",
"ENTITY": "CC-01234",
"PARENTKEY": "",
"PARENTID": "",
"PARENTNAME": "",
"DISPLAYCONTACT": {
"CONTACTNAME": "John(CC-01234)",
"COMPANYNAME": "Company",
"PREFIX": "Test",
"FIRSTNAME": "John",
"LASTNAME": "Doe",
"INITIAL": "Middle",
"PRINTAS": "Print",
"TAXABLE": "true",
"TAXGROUP": "",
"TAXSOLUTIONKEY": "",
"TAXSOLUTIONID": "",
"TAXSCHEDULE": "",
"TAXID": "",
"SIRET": "",
"PHONE1": "5241234545",
"PHONE2": "5241234545",
"CELLPHONE": "5241234545",
"PAGER": "1",
"FAX": "5241234123",
"TAXIDVALIDATIONDATE": "",
"GSTREGISTERED": "",
"TAXCOMPANYNAME": "",
"TAXADDRESS": "",
"EMAIL1": "user@example.com",
"EMAIL2": "user@example.com",
"URL1": "https://www.example.com",
"URL2": "https://www.example.com",
"VISIBLE": "false",
"MAILADDRESS": {
"ADDRESS1": "Address 1",
"ADDRESS2": "Address 2",
"ADDRESS3": "",
"CITY": "City",
"STATE": "City",
"ZIP": "12100",
"COUNTRY": "United States",
"COUNTRYCODE": "US",
"LATITUDE": "",
"LONGITUDE": ""
},
"STATUS": "active"
},
"TERMNAME": "",
"TERMVALUE": "",
"CUSTREPID": "",
"CUSTREPNAME": "",
"RESALENO": "",
"TAXID": "",
"CREDITLIMIT": "1.23",
"TOTALDUE": "0",
"COMMENTS": "",
"ACCOUNTLABEL": "",
"ARACCOUNT": "",
"ARACCOUNTTITLE": "",
"LAST_INVOICEDATE": "",
"LAST_STATEMENTDATE": "",
"DELIVERY_OPTIONS": "Print",
"TERRITORYID": "",
"TERRITORYNAME": "",
"SHIPPINGMETHOD": "",
"CUSTTYPE": "",
"GLGRPKEY": "",
"GLGROUP": "",
"PRICESCHEDULE": "",
"DISCOUNT": "",
"PRICELIST": "",
"VSOEPRICELIST": "",
"CURRENCY": "",
"CONTACTINFO": {
"CONTACTNAME": "",
"PREFIX": "",
"FIRSTNAME": "",
"INITIAL": "",
"LASTNAME": "",
"COMPANYNAME": "",
"PRINTAS": "",
"PHONE1": "",
"PHONE2": "",
"CELLPHONE": "",
"PAGER": "",
"FAX": "",
"EMAIL1": "",
"EMAIL2": "",
"URL1": "",
"URL2": "",
"VISIBLE": "false",
"MAILADDRESS": {
"ADDRESS1": "",
"ADDRESS2": "",
"ADDRESS3": "",
"CITY": "",
"STATE": "",
"ZIP": "",
"COUNTRY": "",
"COUNTRYCODE": ""
}
},
"SHIPTO": {
"CONTACTNAME": "",
"PREFIX": "",
"FIRSTNAME": "",
"INITIAL": "",
"LASTNAME": "",
"COMPANYNAME": "",
"PRINTAS": "",
"TAXABLE": "false",
"TAXGROUP": "",
"TAXSOLUTIONKEY": "",
"TAXSOLUTIONID": "",
"TAXSCHEDULE": "",
"TAXID": "",
"PHONE1": "",
"PHONE2": "",
"CELLPHONE": "",
"PAGER": "",
"FAX": "",
"EMAIL1": "",
"EMAIL2": "",
"URL1": "",
"URL2": "",
"VISIBLE": "false",
"MAILADDRESS": {
"ADDRESS1": "",
"ADDRESS2": "",
"ADDRESS3": "",
"CITY": "",
"STATE": "",
"ZIP": "",
"COUNTRY": "",
"COUNTRYCODE": ""
}
},
"BILLTO": {
"CONTACTNAME": "",
"PREFIX": "",
"FIRSTNAME": "",
"INITIAL": "",
"LASTNAME": "",
"COMPANYNAME": "",
"PRINTAS": "",
"TAXABLE": "false",
"TAXGROUP": "",
"TAXSOLUTIONKEY": "",
"TAXSOLUTIONID": "",
"TAXSCHEDULE": "",
"PHONE1": "",
"PHONE2": "",
"CELLPHONE": "",
"PAGER": "",
"FAX": "",
"EMAIL1": "",
"EMAIL2": "",
"URL1": "",
"URL2": "",
"VISIBLE": "false",
"MAILADDRESS": {
"ADDRESS1": "",
"ADDRESS2": "",
"ADDRESS3": "",
"CITY": "",
"STATE": "",
"ZIP": "",
"COUNTRY": "",
"COUNTRYCODE": ""
}
},
"STATUS": "active",
"ONETIME": "false",
"CUSTMESSAGEID": "",
"ONHOLD": "false",
"PRCLST_OVERRIDE": "C",
"OEPRCLSTKEY": "",
"OEPRICESCHEDKEY": "",
"ENABLEONLINECARDPAYMENT": "true",
"ENABLEONLINEACHPAYMENT": "true",
"VSOEPRCLSTKEY": "",
"WHENMODIFIED": "2024-01-10T23:05:51Z",
"ARINVOICEPRINTTEMPLATEID": "",
"OEQUOTEPRINTTEMPLATEID": "",
"OEORDERPRINTTEMPLATEID": "",
"OELISTPRINTTEMPLATEID": "",
"OEINVOICEPRINTTEMPLATEID": "",
"OEADJPRINTTEMPLATEID": "",
"OEOTHERPRINTTEMPLATEID": "",
"WHENCREATED": "2024-01-10T23:05:51Z",
"CREATEDBY": "43",
"MODIFIEDBY": "43",
"OBJECTRESTRICTION": "Unrestricted",
"DISPLAYCONTACTKEY": "19714",
"CONTACTKEY": "",
"SHIPTOKEY": "",
"BILLTOKEY": "",
"CUSTREPKEY": "",
"SHIPVIAKEY": "",
"TERRITORYKEY": "",
"TERMSKEY": "",
"ACCOUNTLABELKEY": "",
"ACCOUNTKEY": "",
"CUSTTYPEKEY": "",
"PRICESCHEDULEKEY": "",
"OFFSETGLACCOUNTNO": "",
"OFFSETGLACCOUNTNOTITLE": "",
"ADVBILLBY": "",
"ADVBILLBYTYPE": "",
"SUPDOCID": "",
"RETAINAGEPERCENTAGE": "",
"EMAILOPTIN": "false",
"MEGAENTITYKEY": "36",
"MEGAENTITYID": "entity",
"MEGAENTITYNAME": "Entity Name",
"LOCATIONKEY": "36",
"RARNOTES": "",
"HIDEDISPLAYCONTACT": "true",
"SFORCEKEY": ""
}
]
}
}
Get Invoice
Retrieve a single invoice. | key: getInvoice
Output Example Payload
{
"data": {
"_status": "success",
"_functionName": "read",
"_controlId": "423a341f-2327-4469-9afd-3197fd221234",
"_listType": "ARINVOICE",
"_count": 1,
"_data": [
{
"RECORDNO": "1234",
"RECORDTYPE": "ri",
"RECORDID": "Inv1234",
"CONTACTTAXGROUP": "",
"STATE": "Posted",
"RAWSTATE": "A",
"CUSTOMERID": "C-01234",
"CUSTOMERRECORDNO": "11054",
"CUSTOMERNAME": "Customer Name",
"CUSTEMAILOPTIN": "false",
"TRX_ENTITYDUE": "48984.86",
"CUSTMESSAGEID": "",
"CUSTMESSAGE": {
"MESSAGE": ""
},
"DELIVERY_OPTIONS": "Print",
"DOCNUMBER": "3384725",
"DESCRIPTION": "",
"DESCRIPTION2": "",
"TERMNAME": "",
"TERMKEY": "",
"TERMVALUE": "",
"WHENCREATED": "2023-11-09",
"WHENPOSTED": "2023-11-09",
"WHENDISCOUNT": "",
"WHENDUE": "2023-12-09",
"WHENPAID": "",
"BASECURR": "USD",
"CURRENCY": "USD",
"EXCH_RATE_DATE": "",
"EXCH_RATE_TYPE_ID": "",
"EXCHANGE_RATE": "",
"TOTALENTERED": "6002.7",
"TOTALSELECTED": "0",
"TOTALPAID": "0",
"TOTALDUE": "6002.7",
"TRX_TOTALENTERED": "6002.7",
"TRX_TOTALSELECTED": "0",
"TRX_TOTALPAID": "0",
"TRX_TOTALDUE": "6002.7",
"BILLTOPAYTOCONTACTNAME": "Customer Name(CC-01234)",
"SHIPTORETURNTOCONTACTNAME": "Customer Name Site A",
"BILLTOPAYTOKEY": "19419",
"SHIPTORETURNTOKEY": "19484",
"CONTACT": {
"CONTACTNAME": "Customer Name(CC-01234)",
"PREFIX": "",
"FIRSTNAME": "First Name",
"INITIAL": "",
"LASTNAME": "Last Name",
"COMPANYNAME": "Customer Name",
"PRINTAS": "Customer Name",
"PHONE1": "+1 212-555-1123",
"PHONE2": "",
"CELLPHONE": "9175551123",
"PAGER": "",
"FAX": "",
"EMAIL1": "firstlast@client.com",
"EMAIL2": "",
"URL1": "",
"URL2": "",
"VISIBLE": "true",
"MAILADDRESS": {
"ADDRESS1": "",
"ADDRESS2": "89 5th Ave",
"ADDRESS3": "",
"CITY": "New York",
"STATE": "NY",
"ZIP": "10003",
"COUNTRY": "United States",
"COUNTRYCODE": "US"
}
},
"SHIPTO": {
"CONTACTNAME": "Customer Name Site A",
"PREFIX": "",
"FIRSTNAME": "",
"INITIAL": "",
"LASTNAME": "",
"COMPANYNAME": "Test Client",
"PRINTAS": "Customer Name Site A",
"PHONE1": "",
"PHONE2": "",
"CELLPHONE": "",
"PAGER": "",
"FAX": "",
"EMAIL1": "",
"EMAIL2": "",
"URL1": "",
"URL2": "",
"VISIBLE": "true",
"MAILADDRESS": {
"ADDRESS1": "100 Some Ave",
"ADDRESS2": "",
"ADDRESS3": "",
"CITY": "City",
"STATE": "FL",
"ZIP": "33134",
"COUNTRY": "United States",
"COUNTRYCODE": "US"
},
"TAXGROUP": {
"NAME": "",
"RECORDNO": ""
},
"TAXID": ""
},
"BILLTO": {
"CONTACTNAME": "Customer Name(CC-01234)",
"PREFIX": "",
"FIRSTNAME": "First",
"INITIAL": "",
"LASTNAME": "Last",
"COMPANYNAME": "Customer Name",
"PRINTAS": "Customer Name",
"PHONE1": "+1 212-555-1123",
"PHONE2": "",
"CELLPHONE": "9175551123",
"PAGER": "",
"FAX": "",
"EMAIL1": "firstlast@client.com",
"EMAIL2": "",
"URL1": "",
"URL2": "",
"VISIBLE": "true",
"MAILADDRESS": {
"ADDRESS1": "",
"ADDRESS2": "89 5th Ave",
"ADDRESS3": "",
"CITY": "New York",
"STATE": "NY",
"ZIP": "10003",
"COUNTRY": "United States",
"COUNTRYCODE": "US"
}
},
"PRBATCH": "Invoices - test: 2023/11/09 08:30:17:6305 Batch",
"PRBATCHKEY": "1888",
"MODULEKEY": "4.AR",
"DOCUMENT_DOCPARID": "",
"SCHOPKEY": "",
"SYSTEMGENERATED": "F",
"HASPOSTEDREVREC": "F",
"BILLBACKTEMPLATEKEY": "",
"AUWHENCREATED": "2023-11-09T13:30:17Z",
"WHENMODIFIED": "2023-11-09T13:30:18Z",
"CREATEDBY": "50",
"MODIFIEDBY": "50",
"DUE_IN_DAYS": "33",
"TAXSOLUTIONKEY": "",
"TAXSOLUTIONID": "",
"SHOWMULTILINETAX": "",
"TAXMETHOD": "",
"RETAINAGEPERCENTAGE": "",
"TRX_TOTALRETAINED": "0",
"TRX_TOTALRELEASED": "0",
"TOTALRETAINED": "0",
"SUPDOCID": "",
"PROJECTCONTRACTKEY": "",
"PROJECTCONTRACTID": "",
"PROJECTCONTRACTNAME": "",
"DUNNINGCOUNT": "0",
"RETAINAGERELEASED": "false",
"MEGAENTITYKEY": "36",
"MEGAENTITYID": "test",
"MEGAENTITYNAME": "A Company Name",
"BDC_INVOICEID": "",
"BDC_ORGID": "",
"BDC_URL_PREFIX": "",
"REMAINING_AR": "",
"EXTERNALURL": "",
"EXCHRATEDATE": "",
"EXCHRATETYPE": "",
"EXCHRATE": "",
"BILLTOCONTACTNAME": "Customer Name(CC-01234)",
"SHIPTOCONTACTNAME": "Customer Name Site A",
"ARINVOICEITEMS": {
"arinvoiceitem": [
{
"RECORDNO": "12345",
"RECORDKEY": "1234",
"ACCOUNTKEY": "114",
"ACCOUNTNO": "20000",
"OFFSETACCOUNTKEY": "271",
"OFFSETGLACCOUNTNO": "11000",
"OFFSETGLACCOUNTTITLE": "Accounts Receivable",
"ACCOUNTTITLE": "Revenue - Quoted Work",
"ACCOUNTLABELKEY": "",
"ACCOUNTLABEL": "",
"PRENTRYOFFSETACCOUNTKEY": "271",
"ENTRY_DATE": "2023-11-09",
"AMOUNT": "4550",
"TRX_AMOUNT": "4550",
"DEPT": "50",
"DEPARTMENTID": "Recurring",
"DEPARTMENTNAME": "Recurring",
"LOCATION": "36",
"LOCATIONID": "test",
"LOCATIONNAME": "A Company Name",
"ENTRYDESCRIPTION": "Trip: 1, 08:28 AM 11/09/2023, A Company Name LLC, Total amount of Regular Billable Time 4 hours and 33 minutes at the Non Union on demand rate of $1,000.00",
"EXCH_RATE_DATE": "",
"EXCH_RATE_TYPE_ID": "",
"EXCHANGE_RATE": "1",
"ALLOCATIONKEY": "",
"ALLOCATION": "",
"LINEITEM": "T",
"LINE_NO": "1",
"CURRENCY": "USD",
"BASECURR": "USD",
"TOTALPAID": "0",
"TRX_TOTALPAID": "0",
"TOTALSELECTED": "0",
"TRX_TOTALSELECTED": "0",
"SUBTOTAL": "",
"PARENTENTRY": "",
"PAYMENTTAXCAPTURE": "false",
"DEFERREVENUE": "false",
"REVRECTEMPLATEKEY": "",
"REVRECTEMPLATE": "",
"DEFERREDREVACCTKEY": "",
"DEFERREDREVACCTNO": "",
"DEFERREDREVACCTTITLE": "",
"REVRECSTARTDATE": "",
"REVRECENDDATE": "",
"BASELOCATION": "36",
"STATE": "A",
"RECORDTYPE": "ri",
"BILLABLECONTRACTSCHENTRYKEY": "",
"BILLABLECONTRACTUSAGEBILLINGID": "",
"DETAILID": "",
"ISTAX": "false",
"DETAILKEY": "",
"WHENCREATED": "2023-11-09T13:30:18Z",
"WHENMODIFIED": "2023-11-09T13:30:18Z",
"CREATEDBY": "50",
"MODIFIEDBY": "50",
"TAXRATE": "",
"RETAINAGEPERCENTAGE": "",
"TRX_AMOUNTRETAINED": "",
"AMOUNTRETAINED": "",
"HASRETAINAGE": "false",
"TRX_AMOUNTRELEASED": "",
"RETAINAGERELEASED": "false",
"RETAINAGE_OFFSETACCOUNTKEY": "",
"RETAINAGE_OFFSETGLACCOUNTNO": "",
"RETAINAGE_OFFSETGLACCOUNTTITLE": "",
"GLOFFSET": "-1",
"PROJECTCONTRACTID": "",
"PROJECTCONTRACTKEY": "",
"PROJECTCONTRACTLINEID": "",
"PROJECTCONTRACTLINEKEY": "",
"PROJECTCONTRACTNAME": "",
"PROJECTCONTRACTLINENAME": "",
"ISRETAINAGERELEASE": "false",
"ISSUMMARIZED": "false",
"GLDIMDIVISION": "",
"PROJECTDIMKEY": "",
"PROJECTID": "",
"PROJECTNAME": "",
"CUSTOMERDIMKEY": "",
"CUSTOMERID": "",
"CUSTOMERNAME": "",
"VENDORDIMKEY": "",
"VENDORID": "",
"VENDORNAME": "",
"EMPLOYEEDIMKEY": "",
"EMPLOYEEID": "",
"EMPLOYEENAME": "",
"ITEMDIMKEY": "",
"ITEMID": "",
"ITEMNAME": "",
"CLASSDIMKEY": "33",
"CLASSID": "C23",
"CLASSNAME": "Snow",
"RGLDIM101000000010217_10072": "",
"GLACCOUNTNO": "20000",
"GLACCOUNTTITLE": "Revenue - Quoted Work",
"ENTRYEXCHRATEDATE": "",
"ENTRYEXCHRATETYPE": "",
"ENTRYEXCHRATE": "1",
"ENTRYCURRENCY": "USD",
"ENTRYBASECURRENCY": "USD"
},
{
"RECORDNO": "11745",
"RECORDKEY": "1234",
"ACCOUNTKEY": "114",
"ACCOUNTNO": "20000",
"OFFSETACCOUNTKEY": "271",
"OFFSETGLACCOUNTNO": "11000",
"OFFSETGLACCOUNTTITLE": "Accounts Receivable",
"ACCOUNTTITLE": "Revenue - Quoted Work",
"ACCOUNTLABELKEY": "",
"ACCOUNTLABEL": "",
"PRENTRYOFFSETACCOUNTKEY": "271",
"ENTRY_DATE": "2023-11-09",
"AMOUNT": "1060",
"TRX_AMOUNT": "1060",
"DEPT": "50",
"DEPARTMENTID": "Recurring",
"DEPARTMENTNAME": "Recurring",
"LOCATION": "36",
"LOCATIONID": "test",
"LOCATIONNAME": "A Company Name",
"ENTRYDESCRIPTION": "Trip: 1, 08:28 AM 11/09/2023, A Company Name LLC, Total amount of Overtime Billable Time 32 minutes at the Non Union on demand rate of $2,000.00",
"EXCH_RATE_DATE": "",
"EXCH_RATE_TYPE_ID": "",
"EXCHANGE_RATE": "1",
"ALLOCATIONKEY": "",
"ALLOCATION": "",
"LINEITEM": "T",
"LINE_NO": "2",
"CURRENCY": "USD",
"BASECURR": "USD",
"TOTALPAID": "0",
"TRX_TOTALPAID": "0",
"TOTALSELECTED": "0",
"TRX_TOTALSELECTED": "0",
"SUBTOTAL": "",
"PARENTENTRY": "",
"PAYMENTTAXCAPTURE": "false",
"DEFERREVENUE": "false",
"REVRECTEMPLATEKEY": "",
"REVRECTEMPLATE": "",
"DEFERREDREVACCTKEY": "",
"DEFERREDREVACCTNO": "",
"DEFERREDREVACCTTITLE": "",
"REVRECSTARTDATE": "",
"REVRECENDDATE": "",
"BASELOCATION": "36",
"STATE": "A",
"RECORDTYPE": "ri",
"BILLABLECONTRACTSCHENTRYKEY": "",
"BILLABLECONTRACTUSAGEBILLINGID": "",
"DETAILID": "",
"ISTAX": "false",
"DETAILKEY": "",
"WHENCREATED": "2023-11-09T13:30:18Z",
"WHENMODIFIED": "2023-11-09T13:30:18Z",
"CREATEDBY": "50",
"MODIFIEDBY": "50",
"TAXRATE": "",
"RETAINAGEPERCENTAGE": "",
"TRX_AMOUNTRETAINED": "",
"AMOUNTRETAINED": "",
"HASRETAINAGE": "false",
"TRX_AMOUNTRELEASED": "",
"RETAINAGERELEASED": "false",
"RETAINAGE_OFFSETACCOUNTKEY": "",
"RETAINAGE_OFFSETGLACCOUNTNO": "",
"RETAINAGE_OFFSETGLACCOUNTTITLE": "",
"GLOFFSET": "-1",
"PROJECTCONTRACTID": "",
"PROJECTCONTRACTKEY": "",
"PROJECTCONTRACTLINEID": "",
"PROJECTCONTRACTLINEKEY": "",
"PROJECTCONTRACTNAME": "",
"PROJECTCONTRACTLINENAME": "",
"ISRETAINAGERELEASE": "false",
"ISSUMMARIZED": "false",
"GLDIMDIVISION": "",
"PROJECTDIMKEY": "",
"PROJECTID": "",
"PROJECTNAME": "",
"CUSTOMERDIMKEY": "",
"CUSTOMERID": "",
"CUSTOMERNAME": "",
"VENDORDIMKEY": "",
"VENDORID": "",
"VENDORNAME": "",
"EMPLOYEEDIMKEY": "",
"EMPLOYEEID": "",
"EMPLOYEENAME": "",
"ITEMDIMKEY": "",
"ITEMID": "",
"ITEMNAME": "",
"CLASSDIMKEY": "33",
"CLASSID": "C23",
"CLASSNAME": "Snow",
"RGLDIM101000000010217_10072": "",
"GLACCOUNTNO": "20000",
"GLACCOUNTTITLE": "Revenue - Quoted Work",
"ENTRYEXCHRATEDATE": "",
"ENTRYEXCHRATETYPE": "",
"ENTRYEXCHRATE": "1",
"ENTRYCURRENCY": "USD",
"ENTRYBASECURRENCY": "USD"
},
{
"RECORDNO": "11747",
"RECORDKEY": "1234",
"ACCOUNTKEY": "72",
"ACCOUNTNO": "23200",
"OFFSETACCOUNTKEY": "271",
"OFFSETGLACCOUNTNO": "11000",
"OFFSETGLACCOUNTTITLE": "Accounts Receivable",
"ACCOUNTTITLE": "Taxes Payable - Sales Taxes",
"ACCOUNTLABELKEY": "",
"ACCOUNTLABEL": "",
"PRENTRYOFFSETACCOUNTKEY": "271",
"ENTRY_DATE": "2023-11-09",
"AMOUNT": "392.7",
"TRX_AMOUNT": "392.7",
"DEPT": "50",
"DEPARTMENTID": "Recurring",
"DEPARTMENTNAME": "Recurring",
"LOCATION": "36",
"LOCATIONID": "test",
"LOCATIONNAME": "A Company Name",
"ENTRYDESCRIPTION": "",
"EXCH_RATE_DATE": "",
"EXCH_RATE_TYPE_ID": "",
"EXCHANGE_RATE": "1",
"ALLOCATIONKEY": "",
"ALLOCATION": "",
"LINEITEM": "T",
"LINE_NO": "3",
"CURRENCY": "USD",
"BASECURR": "USD",
"TOTALPAID": "0",
"TRX_TOTALPAID": "0",
"TOTALSELECTED": "0",
"TRX_TOTALSELECTED": "0",
"SUBTOTAL": "",
"PARENTENTRY": "",
"PAYMENTTAXCAPTURE": "false",
"DEFERREVENUE": "false",
"REVRECTEMPLATEKEY": "",
"REVRECTEMPLATE": "",
"DEFERREDREVACCTKEY": "",
"DEFERREDREVACCTNO": "",
"DEFERREDREVACCTTITLE": "",
"REVRECSTARTDATE": "",
"REVRECENDDATE": "",
"BASELOCATION": "36",
"STATE": "A",
"RECORDTYPE": "ri",
"BILLABLECONTRACTSCHENTRYKEY": "",
"BILLABLECONTRACTUSAGEBILLINGID": "",
"DETAILID": "",
"ISTAX": "false",
"DETAILKEY": "",
"WHENCREATED": "2023-11-09T13:30:18Z",
"WHENMODIFIED": "2023-11-09T13:30:18Z",
"CREATEDBY": "50",
"MODIFIEDBY": "50",
"TAXRATE": "",
"RETAINAGEPERCENTAGE": "",
"TRX_AMOUNTRETAINED": "",
"AMOUNTRETAINED": "",
"HASRETAINAGE": "false",
"TRX_AMOUNTRELEASED": "",
"RETAINAGERELEASED": "false",
"RETAINAGE_OFFSETACCOUNTKEY": "",
"RETAINAGE_OFFSETGLACCOUNTNO": "",
"RETAINAGE_OFFSETGLACCOUNTTITLE": "",
"GLOFFSET": "-1",
"PROJECTCONTRACTID": "",
"PROJECTCONTRACTKEY": "",
"PROJECTCONTRACTLINEID": "",
"PROJECTCONTRACTLINEKEY": "",
"PROJECTCONTRACTNAME": "",
"PROJECTCONTRACTLINENAME": "",
"ISRETAINAGERELEASE": "false",
"ISSUMMARIZED": "false",
"GLDIMDIVISION": "",
"PROJECTDIMKEY": "",
"PROJECTID": "",
"PROJECTNAME": "",
"CUSTOMERDIMKEY": "",
"CUSTOMERID": "",
"CUSTOMERNAME": "",
"VENDORDIMKEY": "",
"VENDORID": "",
"VENDORNAME": "",
"EMPLOYEEDIMKEY": "",
"EMPLOYEEID": "",
"EMPLOYEENAME": "",
"ITEMDIMKEY": "",
"ITEMID": "",
"ITEMNAME": "",
"CLASSDIMKEY": "33",
"CLASSID": "C23",
"CLASSNAME": "Snow",
"RGLDIM101000000010217_10072": "",
"GLACCOUNTNO": "23200",
"GLACCOUNTTITLE": "Taxes Payable - Sales Taxes",
"ENTRYEXCHRATEDATE": "",
"ENTRYEXCHRATETYPE": "",
"ENTRYEXCHRATE": "1",
"ENTRYCURRENCY": "USD",
"ENTRYBASECURRENCY": "USD"
}
]
},
"CUSTOMER": "C-01234--Customer Name"
}
]
}
}
Get Vendor
Retrieve a single vendor. | key: getVendor
Output Example Payload
{
"data": {
"_status": "success",
"_functionName": "read",
"_controlId": "a3f5bbad-6f3f-417d-a8fc-df1646581234",
"_listType": "VENDOR",
"_count": 1,
"_data": [
{
"RECORDNO": "12345",
"VENDORID": "V-12345",
"NAME": "A vendor",
"NAME1099": "",
"PARENTKEY": "",
"PARENTID": "",
"PARENTNAME": "",
"DISPLAYCONTACT": {
"CONTACTNAME": "A vendor(VV-12345)",
"COMPANYNAME": "Example Company",
"PREFIX": "",
"FIRSTNAME": "",
"LASTNAME": "",
"INITIAL": "",
"PRINTAS": "Example",
"TAXABLE": "false",
"TAXGROUP": "",
"TAXSOLUTIONKEY": "",
"TAXSOLUTIONID": "",
"TAXSCHEDULE": "",
"TAXID": "",
"SIRET": "",
"PHONE1": "",
"PHONE2": "",
"CELLPHONE": "",
"PAGER": "",
"FAX": "",
"TAXIDVALIDATIONDATE": "",
"GSTREGISTERED": "",
"TAXCOMPANYNAME": "",
"TAXADDRESS": "",
"EMAIL1": "",
"EMAIL2": "",
"URL1": "",
"URL2": "",
"VISIBLE": "true",
"MAILADDRESS": {
"ADDRESS1": "",
"ADDRESS2": "",
"ADDRESS3": "",
"CITY": "",
"STATE": "",
"ZIP": "",
"COUNTRY": "United States",
"COUNTRYCODE": "US",
"LATITUDE": "",
"LONGITUDE": ""
},
"STATUS": "active"
},
"ENTITY": "VV-12345",
"TERMNAME": "",
"TERMVALUE": "",
"VENDORACCOUNTNO": "",
"TAXID": "",
"CREDITLIMIT": "15.4",
"TOTALDUE": "0",
"BILLINGTYPE": "openitem",
"VENDTYPE": "",
"VENDTYPE1099TYPE": "",
"GLGROUP": "",
"PRICESCHEDULE": "",
"DISCOUNT": "",
"PRICELIST": "",
"COMMENTS": "",
"ACCOUNTLABEL": "",
"APACCOUNT": "",
"APACCOUNTTITLE": "",
"FORM1099TYPE": "",
"FORM1099BOX": "",
"PAYMENTPRIORITY": "Normal",
"CONTACTINFO": {
"CONTACTNAME": "",
"PREFIX": "",
"FIRSTNAME": "",
"INITIAL": "",
"LASTNAME": "",
"COMPANYNAME": "",
"PRINTAS": "",
"PHONE1": "",
"PHONE2": "",
"CELLPHONE": "",
"PAGER": "",
"FAX": "",
"EMAIL1": "",
"EMAIL2": "",
"URL1": "",
"URL2": "",
"VISIBLE": "false",
"MAILADDRESS": {
"ADDRESS1": "",
"ADDRESS2": "",
"ADDRESS3": "",
"CITY": "",
"STATE": "",
"ZIP": "",
"COUNTRY": "",
"COUNTRYCODE": ""
}
},
"PAYTO": {
"CONTACTNAME": "",
"PREFIX": "",
"FIRSTNAME": "",
"INITIAL": "",
"LASTNAME": "",
"COMPANYNAME": "",
"PRINTAS": "",
"PHONE1": "",
"PHONE2": "",
"CELLPHONE": "",
"PAGER": "",
"FAX": "",
"EMAIL1": "",
"EMAIL2": "",
"URL1": "",
"URL2": "",
"VISIBLE": "false",
"MAILADDRESS": {
"ADDRESS1": "",
"ADDRESS2": "",
"ADDRESS3": "",
"CITY": "",
"STATE": "",
"ZIP": "",
"COUNTRY": "",
"COUNTRYCODE": ""
},
"TAXGROUP": "",
"TAXSOLUTIONKEY": "",
"TAXSOLUTIONID": "",
"TAXSCHEDULE": "",
"TAXID": ""
},
"RETURNTO": {
"CONTACTNAME": "",
"PREFIX": "",
"FIRSTNAME": "",
"INITIAL": "",
"LASTNAME": "",
"COMPANYNAME": "",
"PRINTAS": "",
"PHONE1": "",
"PHONE2": "",
"CELLPHONE": "",
"PAGER": "",
"FAX": "",
"EMAIL1": "",
"EMAIL2": "",
"URL1": "",
"URL2": "",
"VISIBLE": "false",
"MAILADDRESS": {
"ADDRESS1": "",
"ADDRESS2": "",
"ADDRESS3": "",
"CITY": "",
"STATE": "",
"ZIP": "",
"COUNTRY": "",
"COUNTRYCODE": ""
}
},
"STATUS": "inactive",
"STATE": "A",
"PAYDATEVALUE": "",
"ONETIME": "false",
"ONHOLD": "false",
"WHENMODIFIED": "2024-01-11T00:48:17Z",
"ISOWNER": "false",
"DONOTCUTCHECK": "false",
"ALWAYSCREATEBILL": "false",
"OWNER": {
"EQGLACCOUNT": "",
"EQGLACCOUNTLABEL": "",
"HOLDDIST": "",
"ACCOUNTLABEL": {
"LABEL": ""
}
},
"CURRENCY": "",
"PYMTCOUNTRYCODE": "",
"PYMTCURRENCY": "",
"FILEPAYMENTSERVICE": "NONE",
"ACHENABLED": "false",
"WIREENABLED": "false",
"CHECKENABLED": "false",
"ACHBANKROUTINGNUMBER": "",
"ACHACCOUNTNUMBER": "",
"ACHACCOUNTTYPE": "",
"ACHREMITTANCETYPE": "",
"WIREBANKNAME": "",
"WIREBANKROUTINGNUMBER": "",
"WIREACCOUNTNUMBER": "",
"WIREACCOUNTTYPE": "",
"PMPLUSREMITTANCETYPE": "",
"PMPLUSEMAIL": "",
"PMPLUSFAX": "",
"DISPLAYTERMDISCOUNT": "false",
"OEPRCLSTKEY": "",
"DISPLOCACCTNOCHECK": "false",
"WHENCREATED": "2024-01-11T00:48:15Z",
"CREATEDBY": "43",
"MODIFIEDBY": "43",
"PAYMENTNOTIFY": "false",
"PAYMETHODKEY": "",
"OBJECTRESTRICTION": "",
"MERGEPAYMENTREQ": "false",
"DISPLAYCONTACTKEY": "19716",
"PRIMARYCONTACTKEY": "",
"PAYTOKEY": "",
"RETURNTOKEY": "",
"ACCOUNTLABELKEY": "",
"ACCOUNTKEY": "",
"VENDTYPEKEY": "",
"GLGRPKEY": "",
"TERMSKEY": "",
"VENDORACCTNOKEY": "",
"PAYMETHODREC": "",
"OUTSOURCECHECK": "false",
"OUTSOURCECHECKSTATE": "",
"OUTSOURCEACH": "false",
"OUTSOURCEACHSTATE": "",
"OUTSOURCECARD": "false",
"OUTSOURCECARDOVERRIDE": "false",
"CARDSTATE": "",
"VENDORACHACCOUNTID": "",
"VENDORACCOUNTOUTSOURCEACH": "",
"OFFSETGLACCOUNTNO": "",
"OFFSETGLACCOUNTNOTITLE": "",
"CONTACTTO1099": {
"CONTACTNAME": "",
"PREFIX": "",
"FIRSTNAME": "",
"INITIAL": "",
"LASTNAME": "",
"COMPANYNAME": "",
"PRINTAS": "",
"PHONE1": "",
"PHONE2": "",
"CELLPHONE": "",
"PAGER": "",
"FAX": "",
"EMAIL1": "",
"EMAIL2": "",
"URL1": "",
"URL2": "",
"VISIBLE": "false",
"MAILADDRESS": {
"ADDRESS1": "",
"ADDRESS2": "",
"ADDRESS3": "",
"CITY": "",
"STATE": "",
"ZIP": "",
"COUNTRY": "",
"COUNTRYCODE": ""
}
},
"CONTACTKEY1099": "",
"SUPDOCID": "",
"VENDOR_AMEX_ORGANIZATION_ID": "",
"VENDOR_AMEX_ORG_ADDRESS_ID": "",
"VENDOR_AMEX_CD_AFFILIATE_ID": "",
"VENDOR_AMEX_CARD_AFFILIATE_ID": "",
"AMEX_BANK_ACCOUNT_ID": "",
"AMEX_BANK_ACCOUNT_ADDRESS_ID": "",
"RETAINAGEPERCENTAGE": "",
"ISINDIVIDUAL": "false",
"PROVIDERSTATUS": "false",
"WHENLASTBILLED": "",
"WHENLASTPAID": "",
"PROVIDERMISMATCH": "false",
"ENABLE_TPAR": "false",
"NAMETPAR": "",
"MEGAENTITYKEY": "36",
"MEGAENTITYID": "entity",
"MEGAENTITYNAME": "Entity Name",
"HIDEDISPLAYCONTACT": "false"
}
]
}
}
Query and List Records
Lists specified criteria based on a query. | key: queryAndList
Output Example Payload
{
"data": [
{
"RECORDNO": "1234",
"CUSTOMERNAME": "Test Client"
},
{
"RECORDNO": "1235",
"CUSTOMERNAME": "Another Test Client"
}
]
}
Raw Request
Send raw HTTP request to Sage Intacct | key: rawRequest
Update Contact
Update an existing contact. | key: updateContact
Output Example Payload
{
"data": {
"_controlId": "64b091d8-4bd6-4f2e-b175-d90d4e3a1234",
"contactName": "John Doe",
"addressLine1": "123 Main St",
"firstName": "John",
"lastName": "Doe",
"pagerNo": "123",
"taxable": false
}
}
Update Customer
Updates an existing customer in Intacct. The customer is identified by the customer ID. | key: updateCustomer
Output Example Payload
{
"data": {
"_controlId": "49861154-842a-4d25-ab12-2af79dfc1234",
"customFields": [
[
"fieldName1",
123
],
[
"fieldName2",
"someStringValue"
]
],
"customerId": "C-01234",
"customerName": "John Doe",
"excludedFromContactList": false
}
}
Update Invoice
Updates an invoice. | key: updateInvoice
Update Vendor
Updates an existing vendor. | key: updateVendor
Output Example Payload
{
"data": {
"_status": "success",
"_functionName": "update",
"_controlId": "bf13a0a9-e0c7-4aa6-9003-207076761234",
"_listType": "objects",
"_count": 1,
"_data": [
{
"RECORDNO": "1234",
"VENDORID": "V-01234"
}
]
}
}