How to read Nested JSON Array (Source reading as string instead of array) in data flow?

Question

How to read Nested JSON Array (Source reading as string instead of array) in data flow?

Anuganti Suresh 200

string to array01

string to array02

I have nested JSON file as shown in image. In source kycStatus.personal .failureReason reading as string instead of array. How to read failureReason as array?

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Anuganti Suresh 200 Reputation points

2024-01-09T07:57:00.3766667+00:00

Got the point. I was thinking “failureReason” should read as array of complex. “failureReason” field contains an array of two string values. I can able to flow data to sql table.
Berlin Sa 0 Reputation points

2024-01-13T15:27:35.0666667+00:00

Got the point. "failureReason" ought to read as an array of complicated, in my opinion. Two string values are included in an array in the "failureReason" column. Data can flow into a SQL table for me.

1 answer

Your answer

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Anuganti Suresh 200 Reputation points

2024-01-09T07:57:00.3766667+00:00

Got the point. I was thinking “failureReason” should read as array of complex. “failureReason” field contains an array of two string values. I can able to flow data to sql table.
Berlin Sa 0 Reputation points

2024-01-13T15:27:35.0666667+00:00

Got the point. "failureReason" ought to read as an array of complicated, in my opinion. Two string values are included in an array in the "failureReason" column. Data can flow into a SQL table for me.

Answer 1

KranthiPakala-MSFT 46,642 Microsoft Employee Moderator

@Anuganti Suresh Welcome to Microsoft Q&A forum and thanks for reaching out here.

As per your screenshot the value of failiureReason is array of strings. The array is stored in the “failureReason” field of the “Personal” object. (i.e., The “failureReason” field contains an array of two string values).

I don't see any issue here. Could you please elaborate a bit on what is your expectation or expected output or outcome from that column values, so that we could assist accordingly.

Thanks

Share via

How to read Nested JSON Array (Source reading as string instead of array) in data flow?

1 answer

Your answer