on 08-01-2016 6:44 AM
Hi,
Can we create SAP BO4.1 Webi Report using java REST SDK/ API with native SQL which will not use the universe.
Can i get sample example or flow for same.
Thanks,
Amol
Hello Amol,
You can use the Webi RESTful API (nicknamed Raylight) to create a Webi document having a FreeHandSQL dataprovider.
Your application can be implemend in Java or any other technologies/languages able to perform HTTP requests.
Regards,
Anthony
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anthony,
Yes, i have used REST AIP before this and created reports as well.
Can i get any flow or code sample to create report with SQL and not by data provider created by universe.
Thanks
Amol
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amol,
You can launch a search on this forum but I'm not sure to see a snippet about this topic here.
What you have to do is:
- create a fresh document
- add a FHSQL dataprovider (you will have to provide the connection to use)
- send the custom SQL
- refresh data
- save document into CMS
Each one of these calls are documented in the official RESTful guide.
Hope this will help you!
Anthony
Hi Anthony,
Thanks For Reply.
I have searched in forum and in RESTful guide as well but not get any info regarding FHSQL with rest API.
As i am having BO4.1 SP2 server installed, i do not have Raylight samples. So It will be relay appreciate if get java RESTcode from Raylight sample for FHSQL.
Thanks,
Amol.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.