CodePartners - Software Development - Dallas, Texas Software Development - Sage Accpac Customization - SageCRM Customization
Login
pay invoice online  |  remote assistance  |  
  • INTERNET APPLICATION DEVELOPMENT

    • Services
      • Web Application Development
      • Mobile Applications
      • Integration Solutions
      • Staff Augmentation
    • Technologies
    • How we work
    • About us
    • Success stories
    • Blog
  • MID MARKET ERP DEVELOPMENT

    • Intacct
    • Sage CRM
    • Sage
    • Sage Component Catalog
    • How We Work
    • About Us
    • Success Stories
    • Blog

Blog

CodePartners Blog

rss


Manipulating Data through the API Test Tool in Intacct

SHARE THIS
Facebook twitter linkedin Print Print
Print Email

by Sheila Zhang

Recently, I was asked to make some changes to the existing data after completing all master files and opening transactions for a new Intacct company. Since there is no way to go into a database directly to do a mass update, the API Test Tool could be the solution. However, you may not be familiar with how to prepare the XML file. You can use Excel to prepare the XML request for the API Test Tool. In my case, I needed to update the Vendor Price List.

Intacct API tool

Before starting the API Test Tool, you need to know your send ID and password. Once you login to Intacct, you will have your session ID in the address.

Intacct session ID

You can use the session ID to access your company in the API Test Tool.

Intacct session ID

Once you access the API Test Tool successfully, you can query all vendors. In my case, I only need to update the Vendor Price field. In my query, I extracted three fields “RECORDNO, VENDORID, PRICELIST” out of the vendor master files.

Intacct API tool

If you are not familiar with the syntax of the xml request, you can go to http://developer.intacct.com/wiki/functions-object. Look for object “Vendor”.

Intacct developer site

Go to Sample XML to find “Update_Vendor”. Copy the sentence in the rectangle to save as an XML file.

Intacct API sample code

Next, copy the XML data to a text editor, such as notepad, and then save the file in xml format. Here is a trick: You need to duplicate the <update>…</update> section with in <content>…</content>once. So the field title can be shown in the Excel file.

Change the field “NAME” to the field name which needs to be updated. In my case, it is “PRICELIST”.

vendor XML code

The field name can be found in Field Definitions under Vendor object.

Intacct field definitions

After that, you can open the xml file in Excel.

XML file sample

Intacct API tool

Now, you can drag the fields from the XML Source on the right to worksheet. Then put in the price list value for the vendors who need to be updated.

Updated vendor data

Select the field “controlid” to the first column. The value is from API Test Tool.

API test tool value

Once you finish the Excel file, save the file as XML format.

save as XML file

Then open the file in text editor and copy the content into the left box in API Test Tool. Click POST XML, the vendor master file will be updated.

Intacct API test tool

updated Intacct fields

If you need assistance updating fields in Intacct, please contact us.

 




Comments are closed.
On August 13, 2014 in General, Success Stories [Post:by]
Tagged With: API tool, mass change, Intacct / 3178 Views

Search

Categories

  • General (166) rss
  • Development (158) rss
  • Success Stories (40) rss
  • Products (29) rss
  • Uncategorized (18) rss
  • BTerrell Group (5) rss
  • Project Management (22) rss
  • Web Development (57) rss
  • Web application (33) rss
  • Integration (19) rss
  • Mobile Development (7) rss

Archives

  • 2015
    • January (5)
    • February (7)
    • March (6)
    • April (5)
    • May (2)
  • 2014
    • January (13)
    • February (12)
    • March (13)
    • April (12)
    • May (11)
    • June (12)
    • July (11)
    • August (13)
    • September (10)
    • October (8)
    • November (6)
    • December (4)
  • 2013
    • April (73)
    • May (22)
    • June (20)
    • July (20)
    • August (22)
    • September (19)
    • October (13)
    • November (12)
    • December (7)

Tags

.NET Accpac app development application customization application development automation Azure C# cloud components Crystal Reports customization development ERP general ledger HTML5 Intacct Intacct Platform Services integration JQuery load balancer mass update mobile development OCR Order Entry outsourcing PO pricing product development project management REST Sage 300 ERP Sage CRM software integration trigger user interface Visual Studio web application web development website development Workforce Go! .NET ACA accpac Ajax Amazon AP invoices application development Arxis ASP.NET automation Axure BTerrell Group C# Cloud computing CodePartners Constant Contact credit card processing CRM crystal reports custom software Customer Service Customization Delete team project design phase Development doc-link DRILLDWNLK ERP event Excel GLAFS Intacct Intacct Advantage Intacct Platform Services Integration Java script JavaScript jQuery Kerr Consulting LinkedIn Microsoft MSSQL Offshoring outsourcing payroll PCI compliance PCI-DSS Pivot PJC project management sage Sage 300 Sage 300 ERP Sage Accpac ERP Sage CRM Smart Rule social media software testing SQL SQL Query SQL Server staff augmentation sub-ledger success success story TFS Trouble shooting UI design Visual Studio WCF Web API web application web design web development Webinar website Windows Windows Azure XML
Email this article from Codepartners.com
Separate multiple addresses with commas(,)
To: *   Copy me
Subject:
From: *
Message:
ABOUT US / CONTACT US / NEWS & EVENTS
CodePartners / 16200 Addison Rd. STE 270 / Addison, Texas 75001 / Phone: 214-647-2611 / Toll Free: 866-647-2611 / Fax: 214-647-2612 / info@codepartners.com
© 2006 - 2015 codepartners.com All Rights Reserved.