cancel
Showing results for 
Search instead for 
Did you mean: 

Using RESTful API as a data source in Crystal Reports 2016

0 Kudos

Hello,

I am evaluating Crystal Reports and Crystal Reports Server for use in creating and distributing reports. All of our data comes from an existing RESTful API.

  1. How can I use a REST API as a data source in Crystal Reports? I tried to add it as a Web Service but I am not sure what to put in the HTTP(S) WSDL URL or in the Service/Port/Method dialog. The REST call looks like this http://localhost/RestService/api/customer?customerId=123 where the "123" would be a runtime parameter. This returns a JSON with customer data.
  2. Our REST API uses 2-step bearer authentication (https://tools.ietf.org/html/rfc6750) where a call to a login function with a username and password generates a token that is when used in the authentication header for all subsequent REST API calls. Is it possible to implement this in Crystal Reports?
  3. I assume it is possible to use runtime parameters in the URL. Is this correct?

I found this document: https://help.sap.com/doc/businessobject_product_guides_sbo42_en_sbo42_cr_restws_en_pdf/4.2/en-US/sbo... but I don't think this is what I am looking for. I am not trying to develop a REST API, just get data from it.

Sincerely,

Jonathan

Accepted Solutions (1)

Accepted Solutions (1)

daniel_paulsen
Active Contributor

Hi Jonathan,

Crystal Reports will not be able to use REST APIs for a datasource. You would not have control over the oAuth token either.

You would have to write some code to authenticate and consume the rest Endpoint and format the results into an XML format that could be used as a datasource (Try saving to disk and attach the Crystal Report to the XML file as a datasource to ensure the formatting is useable.

Answers (2)

Answers (2)

0 Kudos

Dear Don,

Thank you very much for your reply.

Can what we need to do be done with Crystal Reports without having SAP BusinessObjects Business Intelligence suite?

Can you be a little more specific on what I need to look at for Crystal Reports?

Should I assume that Crystal Reports alone cannot do what we need?

Sincerely,

Jonathan

0 Kudos

Hi Jonathan,

Go here and the RESTFul section in the SDK area and you'll find a bunch of Video's on how to

https://wiki.scn.sap.com/wiki/display/BOBJ

I don't think so, when you log into BOE you will need to get a BOE Token as well.

Don