Hey Scott and Tyler-
Thank you for the help on this. Unfortunately I am still confused on exactly how to grab a file to pass through a flow and haven't had much success over the past couple of days since we discussed it in office hours (so I apologize as this post is lengthy, but hopefully you can pinpoint what I am doing incorrectly and maybe others have had the same issue).
Couple notes: I have replaced the actual URL of where I would will be pulling the file with a public URL. Maybe this doesnt work and where I am going wrong, but not sure. The public URL (as seen in the payload) is: https://s29.q4cdn.com/175625835/files/doc_downloads/test.pdf. I am also trying to do this with the integrator.io (using the mirror endpoint) but am thoroughly confused on it, so I have a feeling this is also a point where I am doing something wrong!😁
Okay... on to the screenshots
Step 1: Payload coming out of my export step post transformation below. I have three arrays where there will/could be attachments. I have grouped these into there own individual object arrays thinking that it will eventually be easier for imports using "one to many" when I eventually get there. The three object arrays that contain attachments are: W9 Attachment, EandOAttachment, and LicenseAttachment. I have put the sample URL in the EandOAttachment array. I am hoping this structure works, but please let me know if you suggest something different.
{
"BrokerageOrIndividual": {
"BrokerageHouseOrIndividual": "Individual",
"BrokerageHouseDBAName": "Brokerage House DBA Name",
"BrokerCompanyName": "Broker Company Name",
"NPNNumber": "Broker NPN",
"FEIN": "FEIN",
"LicensedStates": [
"Maine",
"Maryland",
"Nebraska",
"North Carolina",
"Tennessee",
"Utah"
],
"BrokerageHouseFileName": "Brokerage House DBA Name-thebomb@thebomb.com",
"BrokerFileName": "BrokerFirs BrokerLast-thebomb@thebomb.com"
},
"DemographicInformation": {
"FirstName": "BrokerFirs",
"LastName": "BrokerLast",
"Street": "1234 Broker of the Year Drive",
"City": "Omaha",
"State": "Nebraska",
"ZipCode": "34343",
"Email": "thebomb@thebomb.com",
"Phone": "(342) 242-3232"
},
"W9Attachment": [
{
"Attachment": "https://www.cognitoforms.com/fa/E-kKzFckmUO4P5GWf49ESQ?token=GGCAhuF2qT31vcUbM7YevMgJFhIe9_dv1HEYafADOdAvSHxFRVQnDxw4Pl9wflVg3VDGIYgwbl05G29gTZUwpA$$",
"Type": "W9Form"
}
],
"EandOAttachment": [
{
"Attachment": "https://s29.q4cdn.com/175625835/files/doc_downloads/test.pdf",
"Type": "EandOInsurance"
}
],
"LicenseAttachment": [
{
"Attachment": "https://www.cognitoforms.com/fa/E-kKzFckmUO4P5GWf49ESQ?token=nklx-kV5k6BhIlOwCYZvkzpxbAU_v3FecyAEfG-UXUJ3qW1_JYhWLbg_pfcrOVgO6-N1jb9BlnPJA06r9Rk9Ew$$",
"Type": "LicenseDetailsByState"
}
],
"BankInformation": {
"AccountType": "Checking",
"BankName": "Test Bank",
"AccountNumber": "21321321312",
"RoutingNumber": "21321321321"
}
}
Step 2: This first "step" in the flow (i.e. right after the export step). This is where I am thoroughly confused so I am going to attach a bunch of screenshots and hopefully you can walk me through this. My understanding (from office hours) is this is the step that should GET/Download the file and return a blobkey (specific to that file) that I could pass through the flow and eventually use that blobkey to import the file. I may be misunderstanding this, but I have no idea how this works as this step seems to not fetch anything and return whatever is in the request body. So, my thought is I am not understanding the purpose of this step and need some help.
Screenshots from this step:
Thank you guys so much and I apologize for the lengthy post, but really need some help understanding how to retrieve/download a file to pass through my flow.