Pipeline to move attachment to another table?
I have a pipeline that is pulling in external data and storing it in a holding table until a second pipeline moves them into another table after the data is validated. Some of the fields involved are...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI would add to @Ahuva Brown 's info, I believe you need a pipeline step to create a record to hold the file attachment and then retrieve the record ID from that and use it in a subsequent step to upload the file into that record. Do you use what's called the file transfer handle in order to populate the target field.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
I actually took a slightly more direct path on this. Rather than unpacking the JSON in the intermediate table that is used on the outbound side, I am unpacking the JSON directly in the table where I need the files to reside for short term storage. I will be moving the files out again after about 6 months, but that will involve moving to a storage platform rather than trying to store large amounts of data in my Quickbase apps. Thank you for your suggestions. I was able to move the files, but it just made more sense to unpack the JSON in the table where it is needed rather than in an intermediate table.
------------------------------
Paul Peterson
------------------------------
------------------------------
Paul Peterson
------------------------------