- 07 Dec 2022
- 1 Minute to read
-
Print
-
DarkLight
How to specify elements and extract values when an array is included in the source column JSON
- Updated on 07 Dec 2022
- 1 Minute to read
-
Print
-
DarkLight
This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.
summary
If the JSON of the transfer source column contains an array and you want to get and use the value of a specific element, you can get the necessary element by taking the following steps.
detail
In the item column definition on the "STEP2 Data Preview / Advanced Settings" data setting tab of the target transfer settings, check Expand JSON column of the target JSON column.
Write the value you want to get as follows.
●カラム名:<任意のカラム名>
●JSONパス:[<要素を数値で指定>].<取得したいkey名>
※例: [1].arrayName …要素1に格納されているJSONのkey:ArrayNameのvalueを取得
●データ型:<任意のカラム名>
The following is an example of specifying an element
Click the Save and Re-Preview button.
Make sure the JSON array is expanded.
If you have any other questions or consultations about using the service, please contact Customer Success.