Unanswered

JSON array to DataVerse (CDS) column/field

(0) Share

Report

Posted on by chauhanhardik

Hi community,

I need help with capturing JSON array value to DataVerse (CDS) columns/field, please refer below sample JSON array format,

[

{

"ID": "633128875",

"answer": 1,

"score": 8

{

"ID": "633102840",

"answer": 994290000

{

"ID": "633114253",

"answer": 1,

"score": 5

}

]

NOTE* This is just sample JSON array with very less data(only 3 data objects), and score might not be there in each object.

What I want to do is, capture score value to DataVerse column based on ID from JSON array object.

For an example, if ID = "633114253", then I want to capture score(5) to a column in DataVerse.

Any help is much appreciated!

Regards,

Hardik Chauhan

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @chauhanhardik

Here it is

Above copy the schema as follows:

{

    "type": "array",

    "items": {

        "type": "object",

        "properties": {

            "ID": {

                "type": "string"

            },

            "answer": {

                "type": "integer"

            },

            "score": {

                "type": "integer"

            }

        },

        "required": [

            "ID",

            "answer"

        ]

    }

}

Here is the run result

Was this reply helpful? Yes No
chauhanhardik 37 on at

Like (0)

Report

Hi @abm

I think with your suggested solution, I'll have to create a variable for each ID, and then pass that variable to column in DataVerse. And by doing so, I'll have to create as many variables for each IDs.

And based on ID only, I want to map score value to columns in DataVerse.

Thanks,
Hardik

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @chauhanhardik

I might have misunderstood your question. Do you want to map all the values in Dataverse then after the parse Json step you can add the dataverse step and map the values from the previous step.

Thanks

Was this reply helpful? Yes No
chauhanhardik 37 on at

Like (0)

Report

Yup that's correct @abm

so for that I'll have to write an expression for each column to set score based on ID from JSON array.
something like below table, but I'm struggling with expression to get score based on ID for each column/field.

DataVerse Column expression
Column1 get score where ID = "1"
Column2 get score where ID = "2"
Column3 get score where ID = "3"
Column4 get score where ID = "4"

Regards,
Hardik

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @chauhanhardik

I am not sure about your requirement correctly. Couple of questions.

1. Are you looking to insert all the data from JSON into Dataverse?

2. If you going to filter by ID where you getting the ID from for the filter?

Was this reply helpful? Yes No
chauhanhardik 37 on at

Like (1)

Report

Hi @abm

if possible, shall we connect so, I can explain you.

Regards,
Hardik

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @chauhanhardik

Check your email please?

Thanks

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @chauhanhardik

In order to map all the values in one go you need to create a flat structure of JSON format.

{

    "ID633128875": "633128875",

    "answer633128875": 1,

    "score633128875": 8

  },

  {

    "ID633102840": "633102840",

    "answer633102840": 994290000

  }

Was this reply helpful? Yes No
chauhanhardik 37 on at

Like (1)

Report

Hi @abm

I really appreciate your help here. And it's working as expected.

Thanks and regards,
Hardik Chauhan

Was this reply helpful? Yes No
ATKV 2 on at

Like (0)

Report

@abm , can you please help me with the similar issue? I think you took this offline and helped the original poster. Any help appreciated.

Was this reply helpful? Yes No

Join the conversation

Community site session details

JSON array to DataVerse (CDS) column/field

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

DataVerse Column	expression
Column1	get score where ID = "1"
Column2	get score where ID = "2"
Column3	get score where ID = "3"
Column4	get score where ID = "4"

Community site session details

JSON array to DataVerse (CDS) column/field

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates