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

Resolved web service target needs to return a file

  1. How-to
0
Votes
Undo
  1. Moshe Tangi
    Moshe Tangi
  2. PowerBuilder
  3. Tuesday, 17 July 2018 04:47 AM UTC

Hi all

I have build a target ws. One of its functions needs to return a file.

What is the best way of doing that ?

I have tried convert file into blob but the proxy ws "understands" that as ANY type , why ?

 

Any ideas ?

Thanks

 

Data Source for SQL statement starting with "WITH"
Can not load Sybase.Powerbuilder.Datasource.DB
Responses (3)
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Tuesday, 17 July 2018 10:03 AM UTC
  2. PowerBuilder
  3. # 1

Hi Moshe,

keep the return value/argument as Blob.

When you deploy the WS it will be converted into a byte array (as visible from your PB proxy).

Then you just need to have your WS client reading the byte array:

 

 

byte lbytes[]
Blob lblb
...

// call WS
l_rc = lnv_webservice.myfunction(lbytes)

// convert byte array into blob
lBlobLen = UpperBound(lbytes)
lblb = Blob(Space(lBlobLen), EncodingAnsi!)
For lBytePos = 1 To lBlobLen
   BlobEdit(lblb, lBytePos, lbytes[lBytePos], EncodingANSI!)
Next

 

Best,

.m

Comment
Moshe Tangi
  1. Moshe Tangi
  2. Tuesday, 17 July 2018 10:48 AM UTC
Hi Marco

Thanks

one more question :

Why I can not operate on files on h.d from the ws functions ? I have applied an application pool with administrator user for the application under IIS , I have tested my code outside the ws and its works fine .

I have checked the files permissions …

what is mandatory for iis ws to work if I want to read files from h.d ?

thanks
  1. Helpful
There are no comments made yet.
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Tuesday, 17 July 2018 13:00 PM UTC
  2. PowerBuilder
  3. # 2

Hi,

WSs do not have rights to access folders outside the IIS sandbox.

best,

.m

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 17 July 2018 14:13 PM UTC
Hi Moshe / Marco;

You need to delegate access to the Folder(s) / File(s) outside your Web Service's "sandbox" by having the WS call an thread outside of IIS. You can see an example of this in my PDF example: https://sourceforge.net/projects/stdfndclass/files/Applications/WebService/PDF

The external App thread can move files In/Out of the WS "sandbox" as needed.

HTH

Regards ... Chris
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 17 July 2018 13:37 PM UTC
  2. PowerBuilder
  3. # 3

Hi Moshe;

     Remember that any data returned from a Web Service is formatted in XML. Thus, any BLOB data needs to be converted to a Base64 format in order to pass through the XML schema.

Regards ... Chris

Comment
Moshe Tangi
  1. Moshe Tangi
  2. Tuesday, 17 July 2018 14:46 PM UTC
Hi Chris



" any BLOB data needs to be converted to a Base64 format in order to pass through the XML schema."

What does it mean ? the functions converts a file into blob , now , it needs to get to the client … ??

How do I go from here ?

  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 17 July 2018 15:06 PM UTC
You would need to call the Base64 methods in the O/S to perform that functionality. PB2017R3 will now support the Base64 Encode/Decode command features when released at the end of July, 2018.



For now though - you might want to just declare your WS as returning a BYTE [ ] array and then follow Marco's processing suggestion.
  1. Helpful
Moshe Tangi
  1. Moshe Tangi
  2. Wednesday, 18 July 2018 17:03 PM UTC
I did try to send array of bytes but the pb does not support array as returned parameter from function
  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.