Order of columns in output CSV different than input

Getting Started
,
1

Hello everyone,

I’m a beginner in Make and I’ve created an automation which creates a CSV file from the results of an HTTP call. The CSV file is created succesfully with correct data. So far, so good.

image
image2000×813 104 KB

Unfortunately, the order of columns in the CSV is not correct and different from the source data.

The output bundles of the Iterator-module are correct and in the same order as the results of the HTTP-call. But when I look at the input-bundles from the CSV module, which I believe should correspond with the output of the Iterator, the order is different.

I cannot seem to find how I can configure/control this. I could not find a solution in simular posts on the forum. I hope someone can help me solve this issue.

Thank you for the support!!

Kinds regards, Ronald

2

Output of Iterator with correct column order:

image
image191×710 8.47 KB

Input of CSV module, different/wrong order of columns:

image
image180×648 7.95 KB

3

Hey Ronald,

can you copy the bundles and paste them here so we can test as well?

4

Hi @Stoyan_Vatov, thanks for your quick reply!

Hereby I send you the downloaden bundles:

Input module1 - CSV.json (15.1 KB)

The output bundle was to big, so here is a part of the records, hopefully enough to investigate/test.

Output module 7 - Iterator.json (17.7 KB)

Thanks for all effort.

5

But the first output already has the items in separate bundles? You dont need to iterate on them again.

6

The output of the http call is too long to export, but it look likes it doesn’t have bundles:

image
image412×1083 28.6 KB