Data transfer issue

Questions
1

:bullseye: What is your goal?

Transfer ALL requested open API data to the Google Sheet

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

Hello Makers! I wish somebody could help me with this oen. I’m a beginner in building automations, and I probably shouldn’t be creating an open API data transfer scenario at this stage — but here we are. I can retrieve part of the data and transfer it to Google Sheets. Cell A Yritys= Company, and cell B Y-tunnus = Company ID are good. However, I’m having trouble transferring the registration date=rekisteröinti päivämäärä cell C, company website=www-sivut cell D and company info=toimialainfo cell E into Google Sheets. The data request from the API works, but the transfer does not. I’ve tried mapping the Sheets module in different ways and methods, but I haven’t been able to solve the problem.

:link: Create public scenario page

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

Uusyritystutka - Helsinki.pdf (27.6 KB)

4

Hi @Erno_Ervasti1 - your mapping looks entirely correct.

I checked the API you’re calling and a lot of the results just don’t have a website object so those are coming through as blank.

The date is coming through as an integer because it’s a numeric representation of the date and your column is likely not formatted as a date - this is a Sheets display issue.

Select the date column in your sheet and change Format > Number > Date.

Cheers!

5

Hello Mohapi! And thousand thanks for your reply. Screenshots from HTTP module outputs as you requested. There are many registration date possibilities…confuses me. I ques I should extract business info with right language, in my case finnish (cell C) as you said?? I really appreciate for you help.

image
image1920×1080 239 KB

image
image1920×1080 237 KB

6

Hello SierraV! Thank you very much for your reply. I noticed the same thing. Unfortunately there is not always URL data. Sorry about knowledge but how i can change numeric format to date format?

image
image1920×1080 295 KB

7

Hi @Erno_Ervasti1 - no need to change to a date format in Make!

In your Google Sheet: select the entire column (C), and then in the menu, select Format > Number > (choose a date format from the list).

I don’t know what the menu looks like in Finnish but here’s a help article from Google with a video: Format numbers in a spreadsheet - Computer - Google Docs Editors Help

Cheers!

2 Likes
9

Thank you Sierra. I think I solved the issue.

10

Hey Erno,

mind sharing how? Or tagging which ever of Sierra’s posts was the most helpful as the solution using the button bellow?

image

11

This is srange. I’m still able to se Sierra’s response but not other one. I do not know how they vanished. There was some info what i would like use!! And also I would like thank that person as well

12

Thank you @Erno_Ervasti1, for taking a moment to come back and let us know that the solution Sierra provided worked :flexed_biceps: Always very useful for other users to get this information! And of course, thank you @SierraV for the solution :slight_smile:

1 Like