• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • How to send contents of a CSV file as body of a REST API

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

Resolved How to send contents of a CSV file as body of a REST API

  1. How-to
0
Votes
Undo
  1. VINOD NAIR
    VINOD NAIR
  2. PowerBuilder
  3. Monday, 12 August 2024 15:35 PM UTC

We are using PB 2019 R2 and there is requirement to call a REST API where in we need to send the contents of a CSV formatted file as its payload/body. How can we achieve this via code?

Problem with dropdownlistbox AllowEdit=True when T...
Datastore dynamic with SyntaxFromSql, Failed to re...
Responses (2)
Francisco Martinez @Appeon
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Monday, 12 August 2024 16:04 PM UTC
  2. PowerBuilder
  3. # 1

Hi Vinod,

 

I think you can use the HTTP Client and just post/put the contents of the file to the endpoint with either PostData or SendRequest. Remember to correctly set the Content-Type header to text/csv

 

Regards,
Francisco

Comment
There are no comments made yet.
VINOD NAIR
VINOD NAIR Accepted Answer Pending Moderation
  1. Monday, 12 August 2024 16:51 PM UTC
  2. PowerBuilder
  3. # 2

Hi Francisco,

 

Do you mean we use the below function, read the entire contents of the CSV file into a blob_data variable or is there another way to just point the file directly ?

objectname.SendRequest ( methodName, urlName, blob data )

 

Thanks,

Vinod

Comment
Francisco Martinez @Appeon
  1. Francisco Martinez @Appeon
  2. Monday, 12 August 2024 22:06 PM UTC
There is not, you will have to load the contents manually
  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.