hi! I am fairly new to N8N.
Describe the issue/error/question
Im getting this error from the google sheet node when trying to post some URLS on the google sheet ( after upgrading my instance) :
ERROR: Bad request - please check your parameters
My hypothesis is that it is because the iSET node i have before the google sheet is setting an array of URLS instead of a list of string URLS …
I think this might be the issue as it worked before today I upgraded my instance to .
Regardless of the cause my issue is this:
I need to read this input:
"images":
[
{
"id":
39423396118751,
"product_id":
7988875296991,
"position":
1,
"created_at":
"2023-01-24T13:23:45+01:00",
"updated_at":
"2023-01-24T13:23:45+01:00",
"alt":
null,
"width":
1536,
"height":
2048,
"src":
"https://cdn.shopify.com/s/files/1/0209/5389/0880/products/IMG_5203.jpg?v=1674563025",
"variant_ids":
[
],
"admin_graphql_api_id":
"gid://shopify/ProductImage/39423396118751"
},
{
"id":
39423396053215,
"product_id":
7988875296991,
"position":
2,
"created_at":
"2023-01-24T13:23:45+01:00",
"updated_at":
"2023-01-24T13:23:45+01:00",
"alt":
null,
"width":
1536,
"height":
2048,
"src":
"https://cdn.shopify.com/s/files/1/0209/5389/0880/products/IMG_5204_d0883891-3a46-40b4-b7a0-c7855f4bc377.jpg?v=1674563025",
"variant_ids":
[
],
"admin_graphql_api_id":
"gid://shopify/ProductImage/39423396053215"
},
{
"id":
39423395922143,
"product_id":
7988875296991,
"position":
3,
"created_at":
"2023-01-24T13:23:44+01:00",
"updated_at":
"2023-01-24T13:23:45+01:00",
"alt":
null,
"width":
1536,
"height":
2048,
"src":
"https://cdn.shopify.com/s/files/1/0209/5389/0880/products/IMG_5205_cd0c3fb4-d994-401c-af48-b44905f11bbf.jpg?v=1674563025",
"variant_ids":
[
],
"admin_graphql_api_id":
"gid://shopify/ProductImage/39423395922143"
},
{
"id":
39423396151519,
"product_id":
7988875296991,
"position":
4,
"created_at":
"2023-01-24T13:23:46+01:00",
"updated_at":
"2023-01-24T13:23:46+01:00",
"alt":
null,
"width":
1536,
"height":
2048,
"src":
"https://cdn.shopify.com/s/files/1/0209/5389/0880/products/IMG_5206_cf47356b-3daa-499d-8030-2bdae9d5b7bb.jpg?v=1674563026",
"variant_ids":
[
],
"admin_graphql_api_id":
"gid://shopify/ProductImage/39423396151519"
},
{
"id":
39423395889375,
"product_id":
7988875296991,
"position":
5,
"created_at":
"2023-01-24T13:23:44+01:00",
"updated_at":
"2023-01-24T13:23:46+01:00",
"alt":
null,
"width":
1536,
"height":
2048,
"src":
"https://cdn.shopify.com/s/files/1/0209/5389/0880/products/IMG_5207_e8afe982-d156-4325-b107-3ea0958a8068.jpg?v=1674563026",
"variant_ids":
[
],
"admin_graphql_api_id":
"gid://shopify/ProductImage/39423395889375"
},
{
"id":
39423396249823,
"product_id":
7988875296991,
"position":
6,
"created_at":
"2023-01-24T13:23:46+01:00",
"updated_at":
"2023-01-24T13:23:46+01:00",
"alt":
null,
"width":
1536,
"height":
2048,
"src":
"https://cdn.shopify.com/s/files/1/0209/5389/0880/products/IMG_5208_18ef449a-edb6-4a8c-9623-7e5e9f173921.jpg?v=1674563026",
"variant_ids":
[
],
"admin_graphql_api_id":
"gid://shopify/ProductImage/39423396249823"
},
{
"id":
39423396085983,
"product_id":
7988875296991,
"position":
7,
"created_at":
"2023-01-24T13:23:45+01:00",
"updated_at":
"2023-01-24T13:23:46+01:00",
"alt":
null,
"width":
1536,
"height":
2048,
"src":
"https://cdn.shopify.com/s/files/1/0209/5389/0880/products/IMG_5209_67d78d99-b896-491a-8f0d-081fe18709cd.jpg?v=1674563026",
"variant_ids":
[
],
"admin_graphql_api_id":
"gid://shopify/ProductImage/39423396085983"
},
{
"id":
39423396217055,
"product_id":
7988875296991,
"position":
8,
"created_at":
"2023-01-24T13:23:46+01:00",
"updated_at":
"2023-01-24T13:23:46+01:00",
"alt":
null,
"width":
1536,
"height":
2048,
"src":
"https://cdn.shopify.com/s/files/1/0209/5389/0880/products/IMG_5210_adf64a18-467b-4414-bf74-e070eab9d619.jpg?v=1674563026",
"variant_ids":
[
],
"admin_graphql_api_id":
"gid://shopify/ProductImage/39423396217055"
}
],
And get only the URLS on the “src” key in the “SET” node to post tot he google sheet node.
Until today I had done it through this formula in the SET node:
{{$jmespath($json.images, “[*].src” )}}
But today i noticed after i upgraded my instance to “[email protected]” that this formula wasn’t working anymore as I get an array like this:
Instead of a list of all the URLS which is what I want … but this is just a hypothesis .
Please help
What is the error message (if any)?
Please share the workflow
Share the output returned by the last node
Information on your n8n setup
- n8n version: [email protected]
- Database you’re using (default: SQLite):
- Running n8n with the execution process [own(default), main]:
- Running n8n via [Docker, npm, n8n.cloud, desktop app]: cloud