Workflow execution is ok but at the last node (HTTP Request) I got the output message "Processing is done but no results were found."

Questions
1

Describe the problem/error/question:

My workflow executes ok but the last node (http request) returns "Processing is done but no results were found."

My goal is to enrich some leads with company data. I’ll get data from an API service. The API expects CSV or TXT file.

Each lead has a number called CNPJ (company register in Brazil). I need to get each CNPJ number, write a CSV or TXT file, transform it’s binaries to base64, create a JSON object and send it via HTTP Request.

Well, when I send the JSON and they receive a filesystem-v2 named file and does not match the expected filenam input. They need a CNPJ (number) filename input.

Wha’t am I doing wrong? May be the node "Convert CSV to base64 " it’s not configured properly? I think the error is in the conversion process.

ERROR:

n8n
n8n1279×641 45.9 KB

WORKFLOW

Share the output returned by the last node:

“Processing is done but no results were found.”

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite): DEFAULT
  • n8n EXECUTIONS_PROCESS setting (default: own, main): DEFAULT
  • Running n8n via (Docker, npm, n8n cloud, desktop app): WEBAPP (n8ncloud?)
  • **Operating system:**Windows 11
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hi @handrey89 Welcome to the n8n community! :tada:

Could you please make sure the “Always Output Data” option is enabled?

1210×778 39.6 KB

4

Hello, @mcnaveen. Thanks for the reply.

I’ve already tried that but it didn’t work.

The point is the API server still not creating a return of a download link (CSV file) file cause, even thought the workflow and sending request runs ok, my request still has a error.

I noticed the error may be ocurring in “Convert data to CSV file” or “Convert CSV to Base64”.

Please check the img below:

api2
api21279×621 58.7 KB

As you can see the encoded file has a base64 name ZmlsZXN5c3RlbS12Mg== = filesystem-v2 . The API won’t return any result if the file name is filesystem-v2 , and it’s expects a CNPJ number that’s is a var $json.CNPJ.

I’m struggling to find a way to change the base64content name from ZmlsZXN5c3RlbS12Mg== to a var $json.CNPJ.

Any ideia?

5

Hi @handrey89

Can you show an example of how the CNPJ number would look like?

6

Hello @mcnaveen
how you doing?

For sure.

The CNJP’s standard format is 07.294.568/0001-01

This data comes from spreadsheet as 7294568000101

image
image785×281 18.2 KB

1 Like
7

Can you share the workflow?

8

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.