I hope everyone is doing well. I’m currently working on a project where I need to parse data from a spreadsheet to create new products on Shopify. Although I thought I had successfully parsed the data, I’ve run into an issue where the final array turns out to be empty for some reason.
Example data I want to parse(value of the excel cell):
[
{
"Data": "https://drive.google.com/uc?export=download&id=19K5XVihlxA_VBVj2bqaKUkbrfCzdS6ZZ",
"Alternate text": "Backdrop image 'Mystic Mist' from the 'Enigmatic Elixir' collection, ideal for studio photography.",
"Position": 1
},
{
"Data": "https://drive.google.com/uc?export=download&id=1JV04ajXLFjk6WL6qRt3xQf_W819nWSyp",
"Alternate text": "Another backdrop image from the 'Enigmatic Elixir' collection, perfect for adding magic to your photographs.",
"Position": 2
},
{
"Data": "https://drive.google.com/uc?export=download&id=1HtLPvKbj8VlZ76ej8us4rkvl47GT_F56",
"Alternate text": "Backdrop image 'Mystic Mist' with deep, black elements adding depth.",
"Position": 3
},
{
"Data": "https://drive.google.com/uc?export=download&id=1xRgLFtaqbkaCyTOuvVt0SiTY3UUZVOj-",
"Alternate text": "'Mystic Mist' image with high 8K resolution, ideal for professional photo shoots.",
"Position": 4
},
{
"Data": "https://drive.google.com/uc?export=download&id=1B30Ua-B8gWSNPZYz-Iga6nFlFSxUP2PP",
"Alternate text": "'Mystic Mist' backdrop image with a 16:9 aspect ratio, fitting various formats.",
"Position": 5
}
]
The image property of the output bundle from Shopify is empty because it’s likely the names of the properties in your aggregated array don’t match up with what the Shopify “Images” field is expecting.
Thank you for your response. I should have pasted the configuration for the aggregator. As you can see, I have chosen the target structure type as “Images.”
The Shopify API “product.images” field is expecting an array containing either “src” or “attachment” properties, so it might be a bug with the Shopify module itself?
I’m wondering how I can download an image to the buffer and then use it as the value for the ‘Data’ field in a collection array. The expected data type for the ‘Image’ field is a buffer. When I was testing my links with Curl, they were working fine. However, Make.com probably expects loaded images rather than just links for some reason as you mentioned. I will try work with Google Drive module then.
I have tried downloading the file using the HTTP module and aggregating the response before making the Shopify request, but the value for images still shows an empty array.
I haven’t yet tried using the HTTP module to make POST requests like I was doing with curl. However, to be honest, I would prefer to use a ready-to-go module rather than manually handling requests for every other action in the future.
I now realize that this approach isn’t working as I initially thought it would. Instead of aggregating HTTP responses into another array, it made 5 separate calls to Shopify. However, the array still contains at least onecollection. But on the Shopify module side, I see an empty array and no images are displayed on the site.
Your second aggregator’s source module field should probably be the iterator before the HTTP module.
Could you please share screenshots of the new module fields and filters? It would really help other community members to see what you’re looking at.
You can also export the scenario blueprint file to allow others to replicate the issue. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
If possible, could you also please provide the input/output bundles of the modules by running the scenario, then clicking the bubble on the top-right of each module, taking screenshots of, and copying the contents into this discussion thread:
This will allow others to better assist you. Thanks!
I noticed that in my previous attempt, the HTTP request returned a status of 500. I looked through some tutorials and tried using the HTTP GET file module type, but the behavior remained the same; the arrays weren’t working. Then, I tried using the Google Drive module, and it started to work. Now, for my final step, I want to download all the files and include them in a single Shopify ‘Create Product’ request. I tried using a second iterator and aggregator, but I always ended up with 5 lists of 1 collection.
