Tools module - toNumber fails on HTTP JSON response (Google Distance Matrix)

Questions
1

:bullseye: What is your goal?

Calculate estimated arrival time using Google Distance Matrix API response (duration.value in seconds) inside a Tools - Set multiple variables module

:thinking: What is the problem & what have you tried?

I tried mapping the duration value with these syntaxes:

  • {{4.data.rows[].elements[].duration.value}}
  • {{first(4.data.rows[]).elements[].duration.value}}
  • {{4.data.rows["0"].elements["0"].duration.value}}
  • {{4.data.rows.elements.duration.value}}

All returns: “Function ‘toNumber’ not found” when used inside addSeconds(now; toNumber(...))

HTTP module has Parse response = Yes, Status 200, valid JSON confirmed.

:clipboard: Error messages or input/output bundles

DataError: Failed to map ‘3.value’:
Function ‘formatDate’ finished with error!
Function ‘addSeconds’ finished with error!
Function ‘toNumber’ not found!

JSON structure from HTTP output:

{
  "rows": [{ "elements": [{ "duration": { "value": 1234, "text": "20 mins" } }] }],
  "status": "OK"
}
3

Welcome to the Make community!

What does 4.data output?

Please provide the Output bundle of the Google Distance Matrix API (module [4]) from the Scenario History, or by re-running the scenario.

Expand Instructions ◀

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

A. Upload a Text File

Save each bundle contents in a plain text editor as a moduleNumber-output.txt file. Open the file to check if it has not added additional formatting or encoded the plain text.

  • You can upload files and images to this forum by clicking on the upload button:

    Uploading an attachment here will look like this:
    module1-input.txt (1.2 KB), module1-output.txt (3.4 KB)

B. Insert a Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the bundles AND format them correctly with the “Preformatted Text” (code) button in the rich-text editor. Otherwise the forum software will change the content, making them invalid!

:warning: Formatting IS Important! :warning:

Here are some ways to provide text content in a way that it won’t be modified by the forum.

  • Method 1: Type code fence manually —
    Manually type three backticks ``` in a separate line before and after the content, like this,

    ```
text goes here
```

  • Method 2: Highlight the pasted content, then click the preformatted text/code button —

  • Method 3: Upload your file elsewhere and share the public link —
    This method is only advised for large files exceeding the forum upload limit.

Providing the Output bundle will allow others to replicate what is going on, especially if there are complex data structures (like nested arrays and collections) and data from external services. This helps us with answering your question with valid examples, like mapping raw variable names (instead of the label/display name).

This will allow others to better assist you. Thanks!

— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!

4

Yes this would be because there is no toNumber() function in Make. Its parseNumber().