1. Bertrand Terlat
  2. PowerBuilder
  3. Tuesday, 17 July 2018 16:33 PM UTC

Hi the question concerns Odata connections  : which versions of Odata are compatible with PB2017R2? OdataV4? OdataV3? OdataV2 (it seems to be OK))

 

Thanks in advance for response

Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 17 July 2018 18:09 PM UTC
  2. PowerBuilder
  3. # 1

OData v4 is not compatible.  OData in PowerBuilder is being deprecated in favor of standard REST. 

A new set of objects are being provided in PB 2017 R3 that makes it easy to...

  • Have a REST/JSON Web API be the data source for a single or multiple DataWindows, including Child DataWindows
  • Encode binary data, URLs, etc. 
  • Supports full CRUD functionalities
  • Authenticate using OAuth tokens
  • Encrypt data using symmetric and/or assymetric

I would recommend watching these 2 webinars: 

https://www.appeon.com/company/events/rest-interoperability-%E2%80%93-powerbuilder-2017-r2-new-feature.html

https://www.appeon.com/company/events/hands-look-powerbuilder-2017-r3.html 

And also reading these 2 articles:

https://community.appeon.com/index.php/articles-blogs/tutorials-articles/2-powerbuilder/181-powerbuilder-2017-r2-new-feature-rest

https://community.appeon.com/index.php/blogs/recent-blogs/powerbuilder-s-http-client-evolution 

PowerBuilder 2017 R3 will be available on July 31, 2018

Comment
  1. Bertrand Terlat
  2. Wednesday, 18 July 2018 07:29 AM UTC
Thanks a lot for response!!!
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Wednesday, 18 July 2018 08:27 AM UTC
You're welcome. If this answer solves your problem please mark the answer as accepted. Thanks.
  1. Helpful
There are no comments made yet.
Bruce Armstrong Accepted Answer Pending Moderation
  1. Wednesday, 18 July 2018 14:22 PM UTC
  2. PowerBuilder
  3. # 2

When SAP introduced the feature as a data connection for the DataWindow they implemented V2, perhaps largely because that's the version that their other products (e.g., HANA) supported at the time.

Using the HTTPClient in PB 2017 you can make OData calls directly for any version, you'll just need to handle the results yourself using the JSONParser object.

Comment
  1. Armeen Mazda @Appeon
  2. Wednesday, 18 July 2018 23:22 PM UTC
Bruce made a very important clarification. OData v4 is not compatible with the legacy OData DataWindow feature, but since OData is a REST Web API it can be used in conjunction with DataWindows with full CRUD operations using the new HTTPClient and JSONParser objects provided in PB 2017. So you definitely can move forward with OData V4 if you would like to, but it would require code changes.
  1. Helpful
  1. Bertrand Terlat
  2. Thursday, 19 July 2018 07:35 AM UTC
Thanks both for clarification. If you have an example (We wan find Samples OdataV4 sources here : https://www.odata.org/odata-services/) It would be great to publish it.



Have a good day
  1. Helpful
  1. Bruce Armstrong
  2. Thursday, 19 July 2018 19:46 PM UTC
Look at the REST samples already provided. The only difference is additional arguments to the URL:



https://community.appeon.com/index.php/articles-blogs/tutorials-articles/2-powerbuilder/181-powerbuilder-2017-r2-new-feature-rest
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.