Extract data from extended data fields

Sharetribe Flex uses Extended Data to save marketplace specific data. If you download a CSV from Sharetribe the data sits within a JSON. It can be a hassle to extract the data but don't worry - Lemonado has a tool that makes this easy.

Create a computed column

To be able to use this data to create dashboards it first need to be extracted. In order to do this head to Data sources and click Edit on a the datasource which holds the data. The edit button is yellow and marked on the picture below.

Click on the Create computed column button.

Give the new column (the data you'd like to extract) a name. Select ProtectedData/PublicData/Metadata depending on where the data is.

Then click Pick value. You'll now see an overview of your JSON.

Find the value you'd like to extract by clicking on it. If your value sits within an array you first need to open the array and then navigate to the value you'd like to extract. Once you have found it, close the window by clicking outside the pop-up.

Now hit Save.

And voilà, you have created a computed column.

The computed column can now be used in created any widget.

Extracting arrays from JSON

Sometime the data from your marketplace gets saved into different arrays, or lists. It could be that you have a multiple choice question a marketplace user needs to fill in. For example, you're asking about what services or product they are interested in. Now you want the result from that data to be useful and see a graph of the answers.

Start by clicking the value in your array. Please note that the data in this example will look different than yours.

Now click on the green button to toggle to All array values.

Let's have a look at the extracted data. As you can see it has extracted both "customer" and "provider" and separated them by a comma.

Extracting specific values within arrays

Should you need to specify what is being extracted more, you can click on the purple button and then

And then select the value on which you wish to filter on. Again, not that your JSON will most likely look different.

Note that the purple button doesn't say "All array values", instead it has a filter condition "code=line-item/units".

Using the extracted data

A new column will now appear when you edit or add a widget. You may use the column you created to filter and build any widget.