Skip to main content

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.

 

 

@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. 

 

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

 

 

@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. 

 

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

@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