I have a little problem with the pubchem database. In the first part of my final workflow I am extracting CID based on the exact mass and the second querying is extracting the molecular formula based on CID.
Sometimes (depending on the time of day - it seems like) I end up in the node “get request” column “body” with few rows empty which has an impact on the performance of my workflow. The second extraction of the molecular formula starts with a chunk loop and parallel chunk loop following the get request node, json path and json to table. However, Parallel chunk loop fails (all the time) with the message; “Not all chunks finished. - check individual chunk branches for details”. When I open metanode, “json path” node fails with the message that there is no json column.
I have two questions: How can I avoid missing information in the “body” column and the second question, how can I avoid failed execution?
Thank you in advance