Insert JSON data into CDS

(1) Share

Report

Posted on by Community Power Pla...

Hi Team,

I want to insert output of my data which is in JSON format into CDS. How can I achieve that?

Thank you in advance.

All responses (4)

Answers (1)

tjasonMayo 4 on at

Like (0)

Report

Re: Insert JSON data into CDS

You can now store files directly into Dataverse using File columns.

File columns (Microsoft Dataverse) - Power Apps | Microsoft Docs
Verified answer

Christian Leverenz 1,214 on at

Like (0)

Report

Re: Insert JSON data into CDS

Hi @Anonymous ,
i think, the easiest way would be to create a form with at least the required fields to fill in, create an entityform out of it, then add some javascript to the entityform to call the service and place the responsefields in the corresponding fields in the entityform and click submit ( $("#submit").click() should do the job )
You can also create an invisible iframe on a page where you need this, load the form there and write some gluecode to send data to the iframe via postMessage.
Another possibility is to create a textfield on your (or another...) entity, just write the stringified json object and write a plugin which does all the dirty stuff which could be needed 🙂
Both (the text-json ist just a small variation of the preceding two) should do the job, we did both in some projects.

But: there will/should/could/... be a new feature to be visible in june ( https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/microsoft-powerapps/planned-features#power-apps-portals-improvements ) : CRUD operations for portals ( https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/microsoft-powerapps/web-apis-crud-operations-common-data-service-entities ) . This should make these kind of tasks muc miuch more easy.
Hope this helps,
Christian
Community Power Pla... on at

Like (0)

Report

Re: Insert JSON data into CDS

So I have output something like as shown in the image after particular user logged in. And I want to store data in the form of table. for ex- in the image I have two field under DATA section i.e. answers and evidence. I want that data to be store in table as a single row for the logged in user under respective columns.

Please let me know if you need more clarification.
Thank You.

output JSON.PNG
OOlashyn 3,496 Most Valuable Professional on at

Like (0)

Report

Re: Insert JSON data into CDS

Hi @Anonymous ,

Can you clarify a bit your requirement? Do you want to store a JSON in CDS as a string in the CDS or what? If yes then you can just create a multiline text field on the entity and store data their (just don't forget that you have a maximum number of characters in the field).