hi guys
I have a strange issue. I have created a workflow that reads the data from BigQuery and Voyado. When I run it manually it works fine. But when it is run automatically - it is generating an error.
The problem is that I cannot see when the error took place because when I open Executions - there is no “green lines” - it looks like it was not run at all. But the weirdest thing is that it was run, because I see the result in BQ.
This workflow is run 15-20 minutes (due to the Wait node), but sometime this workflow runs 20 seconds and then of course it is not run at all.
What could be a reason for that? How can I correct that and avoid the errors?
Regards
Krzysztof
n8n ver. 1.101.2
Can you share your workflow in a code block so we can try and run it to see what the issue is
You first node is missing fields. Either set the fields to be accepted or change the dropdown value to take all values coming in
that’s weird. It looks like this in my n8n:
Can you give me an example json of the data you’re pushing into this sub workflow? I see you’re trying to call this workflow from another place
This is the example of input json (that is coming from HTTP Request1
[
{
"@odata.context": "https://api.businesscentral.dynamics.com/v2.0/fyrklove.onmicrosoft.com/production/api/v2.0/$metadata#companies(0f74b6bb-a3ab-ed11-9a8a-000d3a68cb5e)/customers",
"value": [
{
"@odata.etag": "W/\"JzIwOzE3MTY1NzUxMjMwODU3MjgxNzE3MTswMDsn\"",
"number": "K20015",
"email": "[email protected]"
},
{
"@odata.etag": "W/\"JzE5OzM1MDA0NDEzMjM3MzgxMTAwOTYxOzAwOyc=",
"number": "K20016",
"email": "[email protected]"
}
]
}
]
Please can you share your actual workflow again please. None of the nodes are configured. The code block is default and the first http request node has no config of a url etc, so we have no idea what you’re actually trying to do.
Ok great! This looks better. Lemme have a quick look and try run it
Ok so I created your workflow, off course I cant run the first http node as I dont have credentials for the url, but when I call this workflow from another one using your sample data, the sub workflow you shared does run. Can you try and execute your workflow again from the parent calling workflow and then go to this sub workflows execution tab and share what you see. It’s supposed to show which node is throwing an error.
For example, if i run your wrofklow, I can see where the error is, but it’s probably because I disabled the http step
This is how it looks like when it is run automaticaly:
As you can see - it looks like nothing happened, but it took 19 minutes.
And when I try to open that node, I see nothing, like nothing has been run:
When I run that manually - it looks like this:
Please share the workflow you used to call this workflow. Share the workflow in code block and then also share a screen of the execution of that parent workflow.
Please note that this is not a valid variable name and should be avoided by mapping it to a proper name:
Reason being, I suspect that the sub-workflow is trying to convert the json to a js object which might be erroring on that field. Im not too sure if the @ symbol is breaking the execution
When I run that manually - it worked fine:
And it contains the @ character. BTW: those names are coming from Business Central API, so I cannot change that.
This is the workflow I use to run it:
Which one of the workflow calls above calls your sub workflow?
Also where are you setting this data from?
[
{
"@odata.context": "https://api.businesscentral.dynamics.com/v2.0/fyrklove.onmicrosoft.com/production/api/v2.0/$metadata#companies(0f74b6bb-a3ab-ed11-9a8a-000d3a68cb5e)/customers",
"value": [
{
"@odata.etag": "W/\"JzIwOzE3MTY1NzUxMjMwODU3MjgxNzE3MTswMDsn\"",
"number": "K20015",
"email": "[email protected]"
},
{
"@odata.etag": "W/\"JzE5OzM1MDA0NDEzMjM3MzgxMTAwOTYxOzAwOyc=",
"number": "K20016",
"email": "[email protected]"
}
]
}
]
the last one:
Regarding your second question:
in Code1 node there is a URL that is sent to HTTP Request1. This data comes from HTTP Request1
Im wondering if you should try and upgrade your version of n8n? When I test on my side it all works.
Maybe before that try and download the workflow, delete it and re-import it and see if that works
Tried both… and I am still receiving error
Can you see the specific error?
Hi Krysztof_M, different question but you mentioned working with the Business Central API. Could you help me how to connect the business central API into n8n HTTP request node and webhook? This would really help me. 
. I have big project working with business central’s API so maybe we could help eachother out.
