-
Sivaprakash BKR
- PowerBuilder
- Friday, 14 July 2023 05:13 AM UTC
Hello
Using PB 2022 B 1900, Postgresql 15
Need to update image in a database field (bytea datatype). Need to send the image along with the key field(s). How to send it?
Weng through https://community.appeon.com//index.php/qna/q-a/using-rest-client-to-send-file (Using REST client to send file (appeon.com). The solution given doesn't include the key values to update the image into the database.
Another code, that I got somewhere from the web is
HttpClient lnv_Http
Constant Long BlobPartLen = 65536
Blob lblb_PostData, lblb_PostPart
Integer li_rc, li_PartNum
String ls_ServerURL
li_rc = lnv_Http.PostDataStart(ls_ServerURL)
If li_rc = 1 Then
// post the data in parts
do while li_rc = 1
lblb_PostPart = BlobMid(lblb_PostData, li_PartNum * BlobPartLen + 1, BlobPartLen)
li_rc = lnv_Http.PostData(lblb_PostPart, BlobPartLen)
li_PartNum ++
loop
lnv_Http.PostDataEnd()
// get results
ll_StatusCode = lnv_Http.GetResponseStatusCode()
If ll_StatusCode = 200 Then
// HTTP status 200 = OK
Else
End If
End If
I think using the above code, we could send the image.
1. No idea about how to send the key values?
2. What to set in the RequestHeader?. We used to set it as lo_client.SetRequestHeader('Content-Type', 'application/json')
3. If we need to send both key values (as JSON) and Image [ so that both could be received at server side to update the required field in the database ], what could be the settings?
Or any other way(s) available to achieve this?
Happiness Always
BKR Sivaprakash
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.