{"id":2510,"date":"2020-09-09T14:18:34","date_gmt":"2020-09-09T14:18:34","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/?p=2510"},"modified":"2024-07-02T05:59:24","modified_gmt":"2024-07-02T05:59:24","slug":"sage-intacct-custom-report-data-through-web-services-apis","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/","title":{"rendered":"Sage Intacct Custom Report Data through Web Services APIs"},"content":{"rendered":"\n<p><a rel=\"noreferrer noopener\" href=\"https:\/\/www.greytrix.com\/product\/professional-services\/sage-intacct-development-services\" target=\"_blank\">Sage Intacct<\/a> Web Services are the standardized means of direct communication between external applications and Intacct. It supports interoperable interaction over a network using some protocol. Web service API calls are XML-based data exchange systems.<\/p>\n\n\n\n<p>In our <a href=\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/2020\/08\/21\/drop-ship-in-sage-intacct\/\">previous blog<\/a> we saw how we can pull a report of the Drop-ship transactions in Sage Intacct. Although the report can be exported in excel or other formats, sometimes just the report won\u2019t be enough and we might want the report data to be retrieved through web services and then perform some actions on the gathered data. Even this is possible using the Sage Intacct web service call for reading a custom report.<\/p>\n\n\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2020\/09\/readReport.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2020\/09\/readReport.jpg\" alt=\"Read Report\"><\/a><\/p>\n\n\n<p>You have to mention the custom report name in the report tag and the waitTime is the amount of time to wait for getting the response. It can be between 0-30 milliseconds.<\/p>\n\n\n\n<p>The above API request will get the first 100 records from the report data queue (as default page size is 100), a Report Id and a status.<br>Pagesize can be set in the call according to your need.<br>The <strong>ReportId<\/strong> is to be use in another web service call for fetching the next set of records.<br><strong>Status<\/strong> indicates the response state. If it is \u201cDone\u201d, then the first 100 records are fetched in that call itself, otherwise for \u201cPending\u201d status, the response seems to have timed out so you need to call the readMore function using the generated reported.<\/p>\n\n\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2020\/09\/readMore.jpg\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2020\/09\/readMore.jpg\" alt=\"Read More\"><\/a><\/p>\n\n\n<p>Keep on calling the readMore function until number of remaining records is zero.<br>In this manner, data from a Custom Report can be fetched with such an ease. Conceptualize it as a queue is created to hold the data when readReport function is called, further from which we fetch the data with every readMore request.<\/p>\n\n\n\n<p>Also, you can check out the report definition (all the sorting, groupings, arguments applied) for the desired Custom Report by adding an attribute in the readReport function like this &lt;readReport returnDef=\u201dtrue\u201d&gt; following the rest of the api call.<\/p>\n\n\n\n<p>Through this the parameter names can be fetched for passing any run-time parameters to the report data.<\/p>\n\n\n\n<p>Hard-coded parameters are the ones that are internally applied while creating the custom report. Run-time parameters can be passed when requesting report data using readReport web service call.<\/p>\n\n\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2020\/09\/readReportArgs.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"size-full\" style=\"border: 1px solid #A9A9A9; padding: 2px; margin: 2px;\" src=\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2020\/09\/readReportArgs.png\" alt=\"Read More with Arguments\"><\/a><\/p>\n\n\n<p>This is how we can fetch the Custom Report data through web services so conveniently. Once we get the data in XML, we can further carry out actions that cannot be accomplished through reporting and then can also feed it to some external program that would write it in desired format(eg.  like the way we want.<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"<p>Sage Intacct Web Services are the standardized means of direct communication between external applications and Intacct. It supports interoperable interaction over a network using some protocol. Web service API calls are XML-based data exchange systems. In our previous blog we saw how we can pull a report of the Drop-ship transactions in Sage Intacct. Although\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[225,191,34,119],"class_list":["post-2510","post","type-post","status-publish","format-standard","hentry","category-sage-intacct","tag-custom-report","tag-customization-service","tag-sage-intacct","tag-sage-intacct-web-services"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data from Sage Intacct Custom Reports via Web Services APIs<\/title>\n<meta name=\"description\" content=\"Find out more about Web Services APIs for Sage Intacct Custom Report Data.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data from Sage Intacct Custom Reports via Web Services APIs\" \/>\n<meta property=\"og:description\" content=\"Find out more about Web Services APIs for Sage Intacct Custom Report Data.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage Intacct \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-09T14:18:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-02T05:59:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2020\/09\/readReport.jpg\" \/>\n<meta name=\"author\" content=\"Greytrix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greytrix\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/\",\"name\":\"Data from Sage Intacct Custom Reports via Web Services APIs\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2020\/09\/readReport.jpg\",\"datePublished\":\"2020-09-09T14:18:34+00:00\",\"dateModified\":\"2024-07-02T05:59:24+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/e108e7d0e2204e7a4b30748b516741c8\"},\"description\":\"Find out more about Web Services APIs for Sage Intacct Custom Report Data.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2020\/09\/readReport.jpg\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2020\/09\/readReport.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sage Intacct Custom Report Data through Web Services APIs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/\",\"name\":\"Sage Intacct \u2013 Tips, Tricks and Components\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/e108e7d0e2204e7a4b30748b516741c8\",\"name\":\"Greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"Greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageintacct\/author\/sageintacct\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data from Sage Intacct Custom Reports via Web Services APIs","description":"Find out more about Web Services APIs for Sage Intacct Custom Report Data.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/","og_locale":"en_US","og_type":"article","og_title":"Data from Sage Intacct Custom Reports via Web Services APIs","og_description":"Find out more about Web Services APIs for Sage Intacct Custom Report Data.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/","og_site_name":"Sage Intacct \u2013 Tips, Tricks and Components","article_published_time":"2020-09-09T14:18:34+00:00","article_modified_time":"2024-07-02T05:59:24+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2020\/09\/readReport.jpg","type":"","width":"","height":""}],"author":"Greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greytrix","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/","url":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/","name":"Data from Sage Intacct Custom Reports via Web Services APIs","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2020\/09\/readReport.jpg","datePublished":"2020-09-09T14:18:34+00:00","dateModified":"2024-07-02T05:59:24+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/e108e7d0e2204e7a4b30748b516741c8"},"description":"Find out more about Web Services APIs for Sage Intacct Custom Report Data.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2020\/09\/readReport.jpg","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagebusinesscloud\/wp-content\/uploads\/2020\/09\/readReport.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/2020\/09\/09\/sage-intacct-custom-report-data-through-web-services-apis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/"},{"@type":"ListItem","position":2,"name":"Sage Intacct Custom Report Data through Web Services APIs"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/","name":"Sage Intacct \u2013 Tips, Tricks and Components","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/e108e7d0e2204e7a4b30748b516741c8","name":"Greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"Greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/author\/sageintacct\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/posts\/2510","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/comments?post=2510"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/posts\/2510\/revisions"}],"predecessor-version":[{"id":6327,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/posts\/2510\/revisions\/6327"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/media?parent=2510"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/categories?post=2510"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageintacct\/wp-json\/wp\/v2\/tags?post=2510"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}