Arrow

Working with data

Get to know about recommended rows and tables to extract data easily from integration functions.

IntroAnchor Icon

So, you can use integrations and their functions - but now, what about that damn {data} cell? Well, that’s exactly what we’ll be talking about in this lesson: working with data from integration functions.

Data cellsAnchor Icon

In Using Integrations, we used a Crunchbase function to get info about Apple. In the cell where we executed the function, we stored the results in a {data} cell like this:

kb-data-cell

Now, to see what data the function actually returned, we need to use the Data Explorer.

Data ExplorerAnchor Icon

With data cells, if you click on the icon-data-explorer icon, our Data Explorer panel will open up with two tabs:

kb-dataexplorer-recommended-newUI

TabDescription
RecommendedSome one-click options that quickly and easily insert the data into your table. You can choose either a recommended Row or Table.
All dataThe entire response from the external service we used with the function.

For this lesson, we’ll focus just on using the Recommended options to make things nice and simple. We’ll talk more about All data in our Intermediate course.

kb-data-rows-icons

Recommended rows enrich a singular row with some data from the response. This can be, for example, the latitude and longitude of a place, the email and confidence score for a person, or the phone number for a company.

Let’s try to insert one!

  1. In cell C2 (where we previously entered our Crunchbase function), click on the Data Explorer icon-data-explorer icon.
  2. Select Company info.
  3. Choose where to insert the data and press enter.

❇️ Done! You should see some data about Apple!

kb-data-rows-newUI

kb-data-tables-icons

Recommended tables create a whole table with column headers and all that jazz. Depending on the function, you’ll see one or more recommended tables to choose from.

Let's try it out:

  1. In cell C2, click on the Data Explorer icon-data-explorer icon.
  2. Select the Funding Rounds recommended table.
  3. Choose Overwrite.
  4. Choose where to insert it in your table and press enter.

❇️ Done! And look at all that data!

If you change Apple to Feedzai in cell A2 and press Enter, you’ll see that the table automatically updates with new data from Crunchbase. Pretty cool, right?

kb-data-tables-newUI

Table optionsAnchor Icon

Now, you might be wondering what those table options were:

kb-update+insert

Use UPDATE + INSERT if, each time you execute the function, you’d like existing rows to be updated and new ones to be added.

Update example

kb-data-tables-update-newUI

kb-insert

Use INSERT if, each time you execute the function, you want the data to be appended to the table. Great if you want a constant log.

Insert example

kb-data-tables-insert-newUI

kb-overwrite (1)

Use OVERWRITE if, each time you execute the function, you want all the data in the table to be rewritten. Really handy if you’re doing benchmarking.

Overwrite example

kb-data-tables-overwrite-newUI

Up next:Anchor Icon

As you can see, all you need to do to get data out of an integration function is just click and point (we’ll cover how to make custom tables in Rows Intermediate, but for now, you’re golden).

Let’s take stock of what we’ve learned so far:

  • Knowledge of spreadsheets? ✅
  • Using integrations and their functions? ✅
  • Creating tables from data? ✅

But now, instead of creating all these things from scratch each time, wouldn’t it be easier just to use a template to kick start an idea? Well, you’re in luck - we’ve thought of that. Let’s see how to use them!