Contents x
    How to get the value by specifying the element when the source column JSON contains an array
    • 17 Jul 2024
    • Print
    • PDF
    Contents

    How to get the value by specifying the element when the source column JSON contains an array

    • Updated on 17 Jul 2024
    • Print
    • PDF
    Article summary

    summary

    If the JSON of the source column contains an array and you wish to retrieve and use the value of a specific element, you can take the following steps to retrieve the necessary element.

    Details

    1. Check the Expand JSON column for the target JSON column in the item column definition on the Data Settings tab of "STEP2 Data Preview and Detailed Settings" in the Target Transfer Settings.
      image.png

    2. Describe the values you wish to obtain as follows

    　Column name: <arbitrary column name>.
　●JSON path: [<要素を数値で指定>]. <key name to be retrieved>.　
　　*Example: [1].arrayName ...get value of key:ArrayName of JSON stored in element 1
　Data type: <arbitrary column name>.

    Here is an example of specifying an element
    image.png

    1. Save and click the Repreview button.

    2. Please confirm that the JSON array is expanded.

    If you have any other questions or concerns, please contact Customer Success.

    Was this article helpful?
    What's Next