Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved Using the BOX REST API from PowerBuilder

  1. How-to
0
Votes
Undo
  1. Daniel Kervabon
    Daniel Kervabon
  2. PowerBuilder
  3. Thursday, 14 April 2022 16:16 PM UTC

Has anyone used PowerBuilder to retrieve files from Box using the Box REST API?

My company is phasing out FileNet in favor of Box and we need to change a PowerBuilder application to that end. We were able to put together a clunky .NET assembly in PowerBuilder 12.6 to access files via the FileNet API but I'm hoping that we can come up with a cleaner solution. I've just started looking into it but figured I'd ask in case anyone wanted to share their experience.

Thanks for reading,

Daniel

 

ADO.NET with 2022 R2 fails in deployment
PBWebView2 folder?
Responses (4)
Daniel Kervabon
Daniel Kervabon Accepted Answer Pending Moderation
  1. Monday, 28 August 2023 20:46 PM UTC
  2. PowerBuilder
  3. # 1

I forgot to update this when we implemented a solution, my apologies for the delay.

I was unable to get an OAuth connection to Box working using the native PowerBuilder HTTP objects. There may be a way to do it but I couldn't figure it out. I tried using Chilkat Software's ActiveX object (https://www.chilkatsoft.com/downloads_ActiveX.asp) utilizing its OAUTH2, JSON and HTTP objects. It's pretty much a black box as I followed the examples on their site and I got it working (connecting to Box using a JSON Web Token, retrieving files). Given my time constraints this was the best solution for us. 

Comment
There are no comments made yet.
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 14 April 2022 16:25 PM UTC
  2. PowerBuilder
  3. # 2

There is webinar along with code sample how to do this for Dropbox: https://www.appeon.com/developers/library/videos/using-dropbox-rest-api-powerbuilder.html

I imagine if you study that you could adapt it to Box.com.

Comment
Kevin Ridley
  1. Kevin Ridley
  2. Friday, 15 April 2022 17:27 PM UTC
I was just going to post the youtube link and then saw you already have it covered! Let us know how you make out. Key is to create a service account to use and then use the password grant method to get the oauth token. In Dropbox, you create the id and generate the token online and save it. Not sure how Box does it, but most APIs you have to make a token request.
  1. Helpful
There are no comments made yet.
Daniel Kervabon
Daniel Kervabon Accepted Answer Pending Moderation
  1. Thursday, 14 April 2022 16:31 PM UTC
  2. PowerBuilder
  3. # 3

Thanks Armeen, I will take a look.

Comment
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Thursday, 14 April 2022 17:33 PM UTC
  2. PowerBuilder
  3. # 4

i've done it for azure blob service for storing files/images.  that presentation is on appeon elevate download site.  That presentation was before the PB HTTP objects were available, so it is easier to do now.  (my production code is now using the http objects)  If you are still on pb 12.x  you should move to a current version just for the HTTP object.  any blob service would be similar.  

Blob service REST API - Azure Storage | Microsoft Docs

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Thursday, 14 April 2022 17:47 PM UTC
Another great presentation! :-)
  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.