I am using the DataForSEO Get Finance Quote module that pulls data from Google Finance (using my DataForSEO API). If I manually insert the keyword (ticker:market) and run this module all by itself, it pulls the desired data. I can see all the data I want to extract.
But no matter what module I add next; e.g. Sheets, Set Variables, when I map the the data, it won’t come across. (When I map, I can see the correct answers, so I know the mapping is correct).
I’ve taken this up with DataForSEO and they hit the same problem so they are unable to help me further. They’ve suggested I need a formula to complete the data transfer from DataForSEO to the next module. But where do I even begin!
The last image shows how I set up the mapping and could see the data I want. (For example, ‘displayed_name’ equals ‘Microsoft Corp’. So why is it ‘empty’ in the next module?
Welcome to the Make community!
Please provide the output bundles of the trigger module 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, and help you with mapping the raw property names from collections.
This will allow others to better assist you. Thanks!
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
Thank you. I’ve downloaded the DataForSEO and the Set Multiple Variables input/output bundles and am trying to attach them now. (The ‘Set Multiple Variables’ bundles are all ‘NULL’ effectively proving whats in my screenshot of empty/blank data being returned).
The DataFor SEO output bundle has everything I need (as in what I’ve tried to map to the ‘Set Multiple Variables’ module). For example if you search ‘CEO’ or ‘employees’, you will find the data we want:
“ceo”: “Satya Nadella”
“employees”: 228000
PS. My first attempt to upload the text files has not worked. I’ll try another way. But here’s a screenshot of what I see in the downloaded text files
I can’t paste either as the output 10x the 32000 characters. I will try to find another way to upload the text files.
Hoping I’ve found a way to give you a text file. Here is the DataForSEO output bundle. This is really the only bundle with anything in it.
DataForSEO Output Bundle.txt (250.2 KB)
DataForSEO Input Bundle.txt (160 Bytes)
Solution was quite simple once you know how! The DataForSEO output is in an array. I needed to add an interator in between the DataForSEO module and the next module. Then do the mapping. As there was only one array in the DataForSEO output, it’s turned out to be all I need.
3 Likes
