@Lee Savidge I don't see a way either to retrieve these lists via the API. I think it would be a nice enhancement potentially for the REST API. I will ask the owning application team PM if this could be added to the roadmap.

I'm trying to push customer records in from a new integration I am working on. However, the source system use a free text field for country and state/province. This is a pain. I have been led to believe that the countries can be sent as ISO codes, which is great, but the problem is that the state/province cannot be done that way. So, let's assume the source system is trying to send Canada. If I put Canada into the country field it correctly does its stuff and also sets the ISO country code field as the values match. If I put Canada into the ISO country code field it fails as this requires the 2 digit code, CA. If I put CA into the ISO field it correctly sets Canada and the ISO country code field. If I put CA into the country field it fails. So, all this is obvious. I will let the customer know to pass the ISO code and we're good. However, let's say for example, the country is Canada and the source system has a Vancouver address which is in British Columbia. In their state/province field they have BC, they could have B.C. or B C, or British Columbia or even Bitish Columbia. If I send anything other than British Columbia it successfully sends, but that field value is ignored. Is there a way to get out of Intacct, all state/provinces by country? If you use Australia as the country, the state/province drop down changes to the Australian states and territories. I am sure it coes others (weirdly it doesn't set the UK counties list but we can ignore that). So, to summarise, I need a list of all country and states/provinces/territories that Intacct has. Can I get this via a Postman call via the API? I coudn't see a way.

I would imagine it is setting the content type appropriately. If I was curious, I would set up a small web service and call if from the trigger and query the content type just to see, but I would be surprised if it doesn't. That being said, I've never bothered as it is easier to write a key/value pair list than it is to write JSON by hand which is why I always use the name/value pairs.

Great! This is exactly what we want. Thanks Louis.

REST API is subject to the same maintenance windows, it is consistent across all time zones.

Thanks Lee. I'm just wondering why Intacct would offer JSON as an option without setting the content-type header to application/json.

Hi Is the REST API confirming to the usual maintenance windows? Or is there a different window for REST? Also, is the window at consistent times across each timezone?

@Pavel Kabir This is now on the GL teams roadmap and should be available before GA.

Ah I see. If you retrieve the PDF via the API, Intacct will toggle the "PRINTED" field from "No" to "Yes" on the SODOCUMENT object. Just tested this for you. https://developer.intacct.com/api/order-entry/order-entry-transactions/#get-order-entry-transaction-pdf-data <content> <function controlid="testControlId"> <retrievepdf> <SODOCUMENT> <DOCID>Sales Invoice-INV-0051</DOCID> </SODOCUMENT> </retrievepdf> </function> </content>

Hi Louis, Thanks for your reply. We would like to know if it is possible to mark an invoice as "print/emailed" using the API without printing it in Intacct manually. Do you mean using the API to print the invoice to PDF? If so, could you suggest an API function to do this please? Cheers.

Jacky, Thank you so much for the examples. I will run this by the GL team for review and consideration. Can you private message me the sender ID you used to generate your client ID? I need to add the account balance API to your client ID to allow you test. Its currently in limited release as they are still working on the response pagination.

Wayne, If you simply print the Invoice to PDF within Intacct I believe that should trigger the RAWSTATE field to change. Let me know if that doesn't work.

I'm working on building a 2-way integration with Sage Intacct and need to pull company(customers and vendors) and people records from Sage into our system. In our system, people must be tied to a company, so we were hoping to use the contact lists of the companies to tie to people to companies, but I have not been able to find a way to query these contact lists via the .net SDK or the API. I know that people have a "company" field, but it seems that anyone can type anything into this field instead of this being a direct reference to the companies that exist in Sage. Any advice?

I don't know mulesoft, but I use the triggers regularly to post out to an external application and the easiest way is to use name-value pairs. It posts them as a form post, the MIME type is application/x-www-form-urlencoded, and you can pick that up in Mulesoft https://help.mulesoft.com/s/question/0D52T00004mXXkzSAG/xwwwformurlencoded-in-http-request-connector-as-post Your mileage may vary. I write my own APIs in C# using MVC and post out to them using triggers or smart events, but either way, the name-value pairs is the easiest. You write out which fields you want in the arguments text box as a list like this: sessionid={!USERPROFILE.SESSIONID!} endpoint={!API_ENDPOINT!} useremail={!USERPROFILE.EMAIL!} authkey={!COMPANY.AUTH_KEY!} profile=randomstring entityid={!SODOCUMENT.MEGAENTITYID!} type=PriceList implementationorlive=Live sessionorwslogin=webservices The above is an example, but in EVERY smart event/trigger I do, I pass at least the first 3, if anything, just for logging purposes. The rest in this example are either custom fields, standard fields or strings I need to pass. In my C# code, I pick these out from the Request.Form in a foreach loop. After that, you do what you want. foreach (var formVar in Request.Form)

We want to prevent some AR invoices from being emailed from within Intacct. The way we can think of is to mark the document as ‘Printed/Emailed’. But we found that the RAWSTATE field cannot be updated via the API. Are there any other ways to achieve this? Thanks.

@Louis Sterio2 Thanks for updating. Current rest api does not support "Get account balances by dimension". Can your team add a new parameter to make result data group by journal? I will provide expected response with xml format. Sometimes we only need balance data, if we can get the balance group by journal we don't need query GL entry and summary it. Because some companies' gl data is really big, we need make a lot API calls to get all needed gl entry data.

Hi Lindsay, I will give this a look. Thanks.

Hi AJ, I have done this using the same AR Reverse API call (reverse_arpayment) and passing in the AR Advance's RECORDNO. Can you see if that works for you?

My goal is to send JSON formatted data to Mulesoft. Created "HTTP Post" trigger Created a template which has valid JSON Set the Trigger Type properties to JSON Confirmed the preview is generating valid JSON Trigger the trigger -- mulesoft reads the request headers as "application/x-www-form-urlencoded" I would have expected that the headers would be sending application/json in the headers with this option selected. I have tried changing the template's "template type" from "generic" to "http post" and this has not changed. What do I have to do to get the trigger to send the correct content-type headers?

I wanted to make sure I wasn't missing something, but there does not appear to be a way to reverse an AR Advance via the API. Is this correct? Note, I'm not trying to find the reverse of an application of an AR Advance (payment), but the actual reverse of the created, unapplied, AR Advance. Thanks.

@Lindsay Klatzkin Relying on IP whitelisting can be problematic as our public IP addresses may change over time due to various network configuration updates or cloud service policies. This change would potentially disrupt the connectivity if the IP addresses were hard-coded into their security settings. Could explore the possibility of using domain names instead of IP addresses for the basis of whitelisting. Using our domain name (e.g., intacct.com) would allow their security systems to perform a reverse DNS lookup to verify requests coming from our servers. This method is generally more robust as it adapts to changes in IP addresses without requiring frequent manual updates. You can also send the sessionid as an argument to your endpoint {!USERPROFILE.SESSIONID!} to validate.

We are sending API calls to an external API via HTTP Post on a Trigger. For security purposes, they requested that we provide them with a list of IP addresses that these requests will be coming from. I could not find this in the old community forum (could only find IPs for emails and DDS).

I found it! Its in Company > Setup > Configuration > Company > Security tab

I'm testing a page script and get this message: In Company > Admin > Web Services users I created a platform user called 'ajax'. When that didn't work I tried changing the user type to business with full admin and that didn't work either. Thanks

@Jacky Xu Could you provide an example of a current request and response and the a proposed request and response, highlights the changes and add some comments explaining the benefits. I will then run this by the GL team for consideration to see if this is something that can be accommodated or not.