Skip to main content

REST API with Any SQL Stmt

  • January 27, 2025
  • 3 replies
  • 209 views

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

Forum|alt.badge.img+10
  • 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.

 

 

Forum|alt.badge.img+6
  • 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

Forum|alt.badge.img+10
  • 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

 

 

 

Reply


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