Skip to main content

REST API with Any SQL Stmt

  • January 27, 2025
  • 3 replies
  • 209 views
T
Sidekick (Employee)
Forum|alt.badge.img+6

Lesson I have learned:
If you need a REST API with any SQL statement, you can use either the Query Designer or Quick Report.


Example of using REST API with Quick Report:
https://MY_SERVER/main/ifsapplications/projection/v1/QuickReports.svc/QuickReport_xxxxxx(my_parameter='1234'))
 

Note: xxxxxx is a randomly generated number when we create a Quick Report.
Remember to use an underscore in QuickReport_xxxxxx.

 

https://community.ifs.com/framework-experience-infrastructure-cloud-integration-dev-tools-50/single-get-method-to-return-all-the-columns-from-both-parent-and-child-entities-custom-logical-units-from-a-custom-projection-30527?postid=109045#post109045

https://community.ifs.com/framework-experience-infrastructure-cloud-integration-dev-tools-50/use-a-query-quickreport-ial-as-input-for-a-workflow-action-aka-plsql-cursor-47496?postid=161593#post161593

 

3 replies

K
Hero (Partner)
Forum|alt.badge.img+10
  • kvbe
  • Hero (Partner)
  • 202 replies
  • January 27, 2025

​@Tomasz Grzebula  Just be aware there is a bug/feature with the quick  reports that each time a delivery is done that you have to first run the quick report manually otherwise you will get a metadata error. 

https://community.ifs.com/framework-experience-infrastructure-cloud-integration-dev-tools-50/quick-report-projection-used-in-workflow-error-55117?postid=186267#post186267

 

Another option is using an IAL to make the query you want.

 

 
T
1 person likes this
  • T
    Tomasz Grzebula
T
Sidekick (Employee)
Forum|alt.badge.img+6
  • Tomasz Grzebula
  • Author
  • Sidekick (Employee)
  • 58 replies
  • January 28, 2025
kvbe wrote:

​@Tomasz Grzebula  Just be aware there is a bug/feature with the quick  reports that each time a delivery is done that you have to first run the quick report manually otherwise you will get a metadata error. 

https://community.ifs.com/framework-experience-infrastructure-cloud-integration-dev-tools-50/quick-report-projection-used-in-workflow-error-55117?postid=186267#post186267

 

Another option is using an IAL to make the query you want.

 

 

​@kvbe , Thanks for this info.

  1. Was the problem with the metadata error reported to support?
  2. I was not aware of IAL
K
Hero (Partner)
Forum|alt.badge.img+10
  • kvbe
  • Hero (Partner)
  • 202 replies
  • May 8, 2025

​@Tomasz Grzebula  yes reported it and the confirmed it is a limitation at the moment.

 

https://support.ifs.com/csm?id=kb_article&sys_id=0de50aec47c9a21858119642036d43a1

 

 

 
T
1 person likes this
  • T
    Tomasz Grzebula

Reply


Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings