When you get a list of data returned from an action ("an array") you can use the "Write Lists to Other Table" action to send the list to a new table to see each record in its own row. There are two type of lists, (1) 1 field per item, (2) multiple fields per item.
Here are guides to use both ⚡️:
Check how many fields in each item contains. This case arises when an action returns a list with one field per item, like the one shown on the right (returned from the Enrich Company action)
Note how in the allTechnologiesBySlug
list, each item contains only one field (e.g. field 0: google-app-engine, field 1: google-font-api).
Select the Write to Table Action (1 field per item) action. Once you've established whether there are multiple fields per item or just one, select the relevant action.
Set up your inputs. Let's define action inputs together and see how they work.
Source: The action output list, add here the action output list we are interested in exporting, allTechnologiesBySlug
.
Amount [optional]: The number of items in the list to write to. Defaults to 20 items, if you need to export the entire list, enter ALL
.
Target Base: The select option that lets you choose the base you want to export your list to.
Target Table: The select option that lets you choose the table in you want to export your list to.
Target Column: The select option that lets you choose the column you want to export your list to.
**Optional
:** Once you enter details for the "Target Base" and "Target Table", you'll see additional fields pop up corresponding to the columns in your "Target Table". These inputs are optional letting you specify any additional info you want to export in addition to your list.
e.g. to include a helpful description in the "Description" column.
This case is far more common in our action outputs and occurs when you have a list returned containing multiple fields per item, like the one shown below for the Find Keywords in Website action.
results
list, each item contains more than one field (position, title, link, snippet, etc.) Because of this, we will use the Write to Table Action (Multiple fields per item) to export this list.