Set variable producing empty collections from http easybill

I am pulling data from easybill via http and I receive it like this:

In the next step I want to pull the “company_name” which is in data.items from all 12 collections… But it always comes back empty. I am not even able to pull a single value.

The idea is that I am pulling this data and push it back into a typeform dropdown menu but as pointed out, I am not even able to get the data handed over.

output.txt (52.8 KB)

attached also the output file from the http module

Welcome to the Make community!

You don’t need the double quotes around the company_name parameter in the map function. Remove them.

Also, the map function works with ARRAYS. You inserted 15.data, which is NOT an array. Look closely and see which other variables is an array?

You can use the built-in functions map and first to access variables within an array.

e.g.:

{{ first(map(15.data.items; "company_name")) }}

Copy and paste the above line exactly.

For more information, see the “Mapping with arrays” link below.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

Thanks, that is already very helpful.

I tried that now but the variable still comes back empty.

my educated guess is that, as you pointed out “items” is an array, while “1,2,3 etc.” are again a “collection”. Which in turn seems to be the reason I am not getting the company name back but an empty "collection.

tried now “Set variable”, “iterartor” and even changing the http modul from json to html but I am still not able to pull a single data point into the next module. Maybe it is a general issue and I should rebuild it in a new scenario from scratch

If you need further assistance, please provide the following:

Please provide the text (not screenshot) for output bundles of module [15] by running the scenario (you can also get this without re-running your scenario from the History tab).

Click on the white speech bubbles on the top-right of each module and select “Download input/output bundles”.

A. Upload as a Text File

Save each bundle contents in a plain text editor (without formatting) as a bundle.txt file.

You can upload the file here by clicking on this button:

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

  • Method 1: Type code block manually

    Add three backticks ``` before and after the content/bundle, like this:

    ```
    content goes here
    ```

  • Method 2. Highlight and click the format button in the editor

Providing the input/output bundles will allow others to replicate what is going on in the scenario, especially if there are complex data structures (nested arrays and collections) or if external services are involved.

This will allow others to better assist you. Thanks!

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

output easybill.txt (29.7 KB)

here is what the output looks like. I now switched to the easybill module for “search customers” directly.


and this is what choices I have when I want to select a variable value for the “set variable”

output HTTP.txt (52.7 KB)
and here the output if I use the HTTP get function


and what it looks like if I try to set the variable value in the set variable module