Hi Avi,

You can use Microsoft's docs to get an idea how to do this using its REST API: https://learn.microsoft.com/en-us/onedrive/developer/rest-api/getting-started/?view=odsp-graph-online

Once you know how to do this with REST all that remains to do is use PowerBuilder's HTTPClient to authenticate and make the requests.

Regards,
Francisco

Hi Francisco,

Thanks for the link, and I already familiar with it, I was looking for a built-in solution in PB Appeon to be able to access Onedrive the same as accessing the C drive without writing any code for it.

Hi Avi,

Similar to Armeen's questions, I guess it depends what import/ export means and the functionality you are trying to accomplish. Assuming the location is not already a synchronized location and you just wish to open, copy, create etc. files on your OneDrive but with PB's FILE???????() functions then you have a couple of approaches:

1. Map a network drive to your OneDrive and then use that mapped drive letter as you would the C: drive...if this is needed for many users in an organization then the drive mapping should be accomplished as part of Group Policy configurations
2. Hardcode the UNC naming format (minus the user and machine names which would be obtained at run time and concatenated together) of the OneDrive in your PB code such that it would look something like this: "\\" + ls_MACHINENAME + "\Users\" + ls_USERNAME + "\OneDrive"

If you're looking to do more complex things, like getting notifications when files on OneDrive are changed, then the API approach is the way to go.

HTH...regards,

Mark

Hi Armeen/Mark,

Thank you for the comments. What I meant about export/import is - from PB users can export the results on the datawindow into a file like xls or txt and can save it on any drive. The issue that we are having is - the Onedrive is available when you run the application from the local/network drive but it is not available from Citrix, we are not sure if it is a Citrix issue or if it is related to any additional of PB dlls. 

Thank you