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?
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. |
2. Select “Chargebee” from the list. |
3. Choose "From Objects & Fields". |
4. Select the Chargebee object (e.g., Invoice) from the Import Preview window, then hit “Next”5. 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.
Two choices are available for presenting the Expanded (default) view:
|
1. Single Cell: Combines all values into one cell, separated by commas. |
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.
|
5B. JSON - All the fields are combined into a single cell in this display.
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. 7. Congratulations on your first Chargebee import using the JSON flattening feature! 🎉
FAQs for JSON Flattening
Which integrations offer this functionality?
This functionality is available only for certain integrations, such as Chargebee, Shopify, QuickBooks, Jira, and Custom API.
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.