Skip to Content
avatar image
Former Member

How to design Objects in ESR and IB

Hi,

I have requirements in such a way that, I need to to make call to one solution provide to fetch their data. I am briefing how I have to do this so your expert opinion can help me to design PI objects.

1. To my fetch our organization specific data, I need to make a REST call (URL) you one solution provider by passing company key and service account. This will return a Token in response.

2. I need to append this Token into another REST call (many function has been provided for different set of data) to same provider to fetch desired data in XML format.

3. Finally this XML pass has to pass to SQL server DB.

Please help to provide to right approach to design and execute this PI project.

Thanks in Advance!!

~Vikas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jun 11, 2015 at 05:37 PM

    Who initiates the call?(makes the request)

    May be you can design something like below

    Request -> Java mapping(to fetch token) -> Rest adapter(sync) (async-sync bridge)

    Rest response -> mapping -> JDBC receiver

    Rest adapter in sync mode :

    PI REST Adapter - Consuming synchronous RESTful service

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 11, 2015 at 06:39 PM

    Hi Vikas,

    What is your PI version?, not all PI releases support Rest adapter and the SOAP AXIS adapter has limitations with Rest connections. Do you go to work with JSON or only with XML?

    If you can develop the sender code you can divide Hareesh suggestion in three scenarios, if for example you can use the same token to do several requests with the second Rest call, or you need to know the JDBC insert response. If you don't have this circunstances, no doubt Hareesh suggestion is the best choice in my opinion.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 16, 2015 at 04:45 AM

    Thanks Hareesh, Vila for your reply.

    We don't have REST adaptor in our landscape so not able to go with this approach, so apart from this approach can you please suggest me something else? Thanks!!

    ~Vikas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 22, 2015 at 01:13 PM

    Hello Vikas,

    Please upgrade your system to PI 7.31 SP16 (dual stack)very latest  (or) go to P0 7.4 SP10.

    It contains latest features of Standard REST adapter.

    Thanks,
    Sateesh

    Add comment
    10|10000 characters needed characters exceeded