{"id":29945,"date":"2026-03-06T07:08:25","date_gmt":"2026-03-06T07:08:25","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=29945"},"modified":"2026-03-06T07:15:15","modified_gmt":"2026-03-06T07:15:15","slug":"gumu-sage-100-web-api-direct-query-support-using-api-method","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/","title":{"rendered":"GUMU&#x2122; Sage 100 Web API \u2013 Direct Query Support Using API Method"},"content":{"rendered":"\n<p>Welcome back to our <strong><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s=GUMU+web+api\">GUMU&#x2122; Sage 100 WebAPI<\/a> blog series!<\/strong><br><br>In our earlier blogs, we discussed how the <strong><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2025\/03\/18\/gumu-webapi-performance-matrix\/\">GUMU&#x2122; Sage 100 WebAPI<\/a><\/strong> improves performance and flexibility compared to the legacy <strong>SData API<\/strong>. Today, we will look at another powerful capability introduced in the new API \u2014 <strong>Direct Query Execution using API methods<\/strong>.<br><br>This feature allows developers and integration platforms to execute queries directly against Sage 100 tables using a simple API request.<br><br><strong>Query Support Through API Method<\/strong><br>With the new <strong>GUMU&#x2122; Sage 100 WebAPI<\/strong>, users can execute queries directly through the API by passing a query statement inside the request payload.<br>For example, a simple API request can fetch customer records from Sage 100 using a query like:<br>SELECT * FROM AR_Customer<br>This means external systems can retrieve data directly from Sage 100 tables without the need to create multiple endpoints or custom routines.<br><br><strong>Sample API Request<\/strong><br>Below is an example request structure that demonstrates how a query can be executed through the API.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?xml version=\"1.0\" encoding=\"UTF-8\"?&gt;\n&lt;entry xmlns=\"http:\/\/www.w3.org\/2005\/Atom\" xmlns:atom=\"http:\/\/www.w3.org\/2005\/Atom\" xmlns:cf=\"http:\/\/www.microsoft.com\/schemas\/rss\/core\/2005\" xmlns:http=\"http:\/\/schemas.sage.com\/sdata\/http\/2008\/1\" xmlns:opensearch=\"http:\/\/a9.com\/-\/spec\/opensearch\/1.1\/\" xmlns:sdata=\"http:\/\/schemas.sage.com\/sdata\/2008\/1\" xmlns:sme=\"http:\/\/schemas.sage.com\/sdata\/sme\/2007\" xmlns:sync=\"http:\/\/schemas.sage.com\/sdata\/sync\/2008\/1\" xmlns:xs=\"http:\/\/www.w3.org\/2001\/XMLSchema\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"&gt;\n    &lt;sdata:payload&gt;\n        &lt;GT_Query xmlns=\"\"&gt;\n            &lt;Query&gt;SELECT * FROM AR_Customer&lt;\/Query&gt;\n        &lt;\/GT_Query&gt;\n    &lt;\/sdata:payload&gt;\n&lt;\/entry&gt;\n<\/code><\/pre>\n\n\n\n<p>In this request:<br><strong>GT_Query<\/strong> represents the query execution object.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The <strong>Query tag<\/strong> contains the SQL-like statement.<\/li>\n\n\n\n<li>The <strong>Query tag<\/strong> contains the SQL-like statement.<\/li>\n\n\n\n<li>The API processes the query and returns the requested records.<br><\/li>\n<\/ul>\n\n\n\n<p>The <strong>GUMU&#x2122; Sage 100 WebAPI<\/strong> also provides a <strong>Swagger interface<\/strong> where you can easily test queries and explore API capabilities.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"572\" src=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-05-150857-1-1024x572.png\" alt=\"\" class=\"wp-image-29947\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-05-150857-1-1024x572.png 1024w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-05-150857-1-300x167.png 300w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-05-150857-1-768x429.png 768w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-05-150857-1-660x368.png 660w, https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-05-150857-1.png 1195w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Key Advantages<\/strong><br><strong>Advanced Query Capabilities<\/strong><br>The API allows developers to execute powerful SQL-like queries including filtering, sorting, and <strong>join operations across multiple tables<\/strong>.<\/p>\n\n\n\n<p>For example, integrations can retrieve related information such as customer and order details in a single query, reducing the need for multiple API calls.<br><br>For more information on our integration solutions, please contact us at&nbsp;<a href=\"mailto:sage@greytrix.com\">sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Welcome back to our GUMU&#x2122; Sage 100 WebAPI blog series! In our earlier blogs, we discussed how the GUMU&#x2122; Sage 100 WebAPI improves performance and flexibility compared to the legacy SData API. Today, we will look at another powerful capability introduced in the new API \u2014 Direct Query Execution using API methods. This feature allows\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/\">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":[4206,4723,192,4657,4664,1],"tags":[1258,1286,1435],"class_list":["post-29945","post","type-post","status-publish","format-standard","hentry","category-gumu-integration","category-gumu-sage-100-web-api","category-integration-sage-crm","category-sage-100","category-sage-100-web-api","category-uncategorized","tag-gumu-integration","tag-gumumas","tag-integration"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>GUMU&#x2122; Sage 100 Web API \u2013 Direct Query Support Using API Method - Sage CRM \u2013 Tips, Tricks and Components<\/title>\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\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GUMU&#x2122; Sage 100 Web API \u2013 Direct Query Support Using API Method - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Welcome back to our GUMU&#x2122; Sage 100 WebAPI blog series! In our earlier blogs, we discussed how the GUMU&#x2122; Sage 100 WebAPI improves performance and flexibility compared to the legacy SData API. Today, we will look at another powerful capability introduced in the new API \u2014 Direct Query Execution using API methods. This feature allows\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2026-03-06T07:08:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-06T07:15:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-05-150857-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1195\" \/>\n\t<meta property=\"og:image:height\" content=\"667\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/\",\"name\":\"GUMU&#x2122; Sage 100 Web API \u2013 Direct Query Support Using API Method - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-05-150857-1-1024x572.png\",\"datePublished\":\"2026-03-06T07:08:25+00:00\",\"dateModified\":\"2026-03-06T07:15:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-05-150857-1.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-05-150857-1.png\",\"width\":1195,\"height\":667},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"GUMU&#x2122; Sage 100 Web API \u2013 Direct Query Support Using API Method\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips &amp; tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?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\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/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\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"GUMU&#x2122; Sage 100 Web API \u2013 Direct Query Support Using API Method - Sage CRM \u2013 Tips, Tricks and Components","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\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/","og_locale":"en_US","og_type":"article","og_title":"GUMU&#x2122; Sage 100 Web API \u2013 Direct Query Support Using API Method - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Welcome back to our GUMU&#x2122; Sage 100 WebAPI blog series! In our earlier blogs, we discussed how the GUMU&#x2122; Sage 100 WebAPI improves performance and flexibility compared to the legacy SData API. Today, we will look at another powerful capability introduced in the new API \u2014 Direct Query Execution using API methods. This feature allows\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2026-03-06T07:08:25+00:00","article_modified_time":"2026-03-06T07:15:15+00:00","og_image":[{"width":1195,"height":667,"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-05-150857-1.png","type":"image\/png"}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/","name":"GUMU&#x2122; Sage 100 Web API \u2013 Direct Query Support Using API Method - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-05-150857-1-1024x572.png","datePublished":"2026-03-06T07:08:25+00:00","dateModified":"2026-03-06T07:15:15+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-05-150857-1.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2026\/03\/Screenshot-2026-03-05-150857-1.png","width":1195,"height":667},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2026\/03\/06\/gumu-sage-100-web-api-direct-query-support-using-api-method\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"GUMU&#x2122; Sage 100 Web API \u2013 Direct Query Support Using API Method"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips &amp; tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?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\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/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":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/29945","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=29945"}],"version-history":[{"count":4,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/29945\/revisions"}],"predecessor-version":[{"id":29961,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/29945\/revisions\/29961"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=29945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=29945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=29945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}