Question
Charles Schwab
US
Last activity: 12 Feb 2024 14:56 EST
How to Save rest Api response content to CSV in Pega Robotics
I have a requirement. i will be execution Pega SPOS rest Api call to download the file from repository, which is S3 here, response of the Api call is csv text mapped to string. I need to save the content to csv or a text.
i am not able to identify the delimiter to split the csv string content and save it to lookup table.
Please suggest the specific toolbar options to split the content and as well as save it to a csv file.
Accepted Solution
Updated: 12 Feb 2024 14:55 EST
Pegasystems Inc.
US
@AnuroopSamratS16978510 I apologize for the confusion. You should right-click inside of the tab of the Toolbox where you want the method added. I generally add these to the General tab.
Updated: 6 Feb 2024 7:53 EST
Commonwealth Bank of Australia
IN
Response of the Api call is csv text mapped to string u wanted to save the content to csv or a text.
could you please refer the following reference link which may help you in delimiter to split the csv string content and save it to lookup table
Response of the Api call is csv text mapped to string u wanted to save the content to csv or a text.
could you please refer the following reference link which may help you in delimiter to split the csv string content and save it to lookup table
Convert a TXT file into CSV format in Pega Robot Studio | Support Center Hope this would be helpful! Thanks and Regards Swathi Duvvala
Charles Schwab
US
@SWATHI SRINIVAS i need to save the rest Api response in a csv. Need the process for it. The reference link you shared is having info for converting txt file to csv.
Updated: 8 Feb 2024 8:39 EST
Pegasystems Inc.
US
@AnuroopSamratS16978510 Can you provide an example of the string? If the string is already in whatever format you eish to save to the file, you can use a Static method from the GAC to write a string to a file.
In 19.1, you would right-click on the Toolbox and select "Choose items". You would then select the "Global Assembly Cache" radio button. Select the latest "mscorlib" assembly. Locate the "File" node and find the WriteAllText method. Check it to add it to your Toolbox.
Updated: 8 Feb 2024 18:25 EST
Charles Schwab
US
@ThomasSasnett string data is in below format 8888888,123CRLF
9999999,-123CRLF
9955555,-123CRLF
I tried right-click on the Toolbox, but i am not seeing the "Choose items" options
Accepted Solution
Updated: 12 Feb 2024 14:55 EST
Pegasystems Inc.
US
@AnuroopSamratS16978510 I apologize for the confusion. You should right-click inside of the tab of the Toolbox where you want the method added. I generally add these to the General tab.
Charles Schwab
US
@ThomasSasnett Thank you for the clarification.