Nested JSON Field Expansion

Section header image mobile

Coefficient's JSON Flattening feature allows users to neatly expand and flatten nested JSON fields during import, using a comma-separated list (in a single cell) or split across multiple rows - enhancing the richness of data points across connectors.

How do I apply JSON Flattening to my import?

FAQs for JSON Flattening

How do I apply JSON Flattening to my import?

Example: Import from Chargebee pulling Invoices (object) and Line items (field). (Line items contain details on each line item and can enclose multiple items per invoice)

1. Open the Coefficient Sidebar and click on the “Import from…” button.

ImportFrom.png

2. Select “Chargebee” from the list.

ImportFromChargebee.png

3. Choose "From Objects & Fields".

Screenshot 2023-10-13 at 8.47.00 PM.png

4. Select the Chargebee object (e.g., Invoice) from the Import Preview window, then hit “Next”Screenshot 2024-04-06 at 6.32.49 AM.png5. Search for the "Line Items" field and check the box beside it to include it in your import. Then click the three dots next to the field, allowing you to select your preferred display for multiple values.

There are two ways you can view your Line Items:

5A. Expanded (default) - In this display, the entries under "Line Items" are divided into separate fields, allowing you to choose them individually for your import.

Screenshot 2024-04-06 at 6.45.11 AM.png Screenshot 2024-04-13 at 6.57.35 AM.png

Two choices are available for presenting the Expanded (default) view:

1. Single Cell: Combines all values into one cell, separated by commas.

Screenshot 2024-04-09 at 7.12.14 AM.png

2. Split to Rows: Distributes values across separate rows. Enable the "Leave other rows blank" option if you want to display common field values only once.

Screenshot 2024-04-09 at 7.13.00 AM.png

5B. JSON - All the fields are combined into a single cell in this display.

Screenshot 2024-04-06 at 6.43.30 AM.png Screenshot 2024-04-06 at 6.44.33 AM.png

6. Customize your import by adding filters, sorts, or limits as needed. Then click “Import” on the top right of your screen.

ℹ️ NOTE: The preview only shows a sample of the results that will be included in your import. 
Screenshot 2024-04-12 at 4.00.19 AM.png7
. Congratulations on your first Chargebee import using the JSON flattening feature! 🎉

Screenshot 2024-04-06 at 6.52.00 AM.pngFAQs for JSON Flattening

Which integrations offer this functionality?

This functionality is available only for certain integrations, such as Chargebee, Shopify, QuickBooks, and Custom API. (Jira should be coming soon!)

Will this impact all my existing imports?

Existing imports will remain unchanged and continue to import data as they were originally configured. However, users can manually edit them to utilize this feature.

 

Was this article helpful? 0 out of 0 found this helpful