Skip to Content
avatar image
Former Member

Using RESTful API as a data source in Crystal Reports 2016

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/sbo42_cr_restws_en.pdf 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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 13, 2018 at 10:12 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 13, 2018 at 04:03 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 13, 2018 at 04:26 PM

    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

    Add comment
    10|10000 characters needed characters exceeded