How to load attachment via data source using flow designer?

Kavithan A1
Tera Contributor

‎07-11-2022 10:50 PM

1) I need to upload a record(xlsx) to a table via data source using flow designer.

2) The record should be ordered form service catalog item.

3) I have already created data source and transform maps.

4) I have partially done my requirement like i have moved the attachment form requested item to data source.

how to load the records and transforming is pending. Anyone suggest me to how to achieve this ?

 

 

Labels:
0 Helpfuls
  • 1,623 Views
1 REPLY 1

Ethan Davies
Mega Sage
Mega Sage

‎07-29-2022 07:47 PM

Hey Kavitha,

This is certainly possible, but it requires us to script that action of actually loading and transforming the data. I recommend reading this article to find out more.

Since you are using Flow Designer you will need to approach it a little differently. The code required to load and transform data will need to be placed in a custom Flow Action and then called by your main Flow.

I actually wrote an answer on this question as well that might help you. That code will get your data source data to load into the Import Set, but you will then need to use the transform API to actually transform the data.

Best of luck, and hope this helps.

Please mark this answer as correct or helpful if it solved your issue, thanks!