Adding Headings in JQ Query results displayed as HTML

[natapi]

I wanted to Add Headings in RichText Component which contains results from JQ Query displayed as HTML.

Refer to attached screenshots:

I want to display End Results as follows:

[MaximeBaker]

I am not sure to follow you… What do you want to do? Convert the JSON ? If so, use can use Query JSON column to get each property value in separated columns.

[natapi]

Thanks for getting back. I have converted the JSON and have data in column. But I want to display(TO Be State) JSON elements in list format with headings i.e.

1. “format”: true,
2. “domain”: “gmail.com”,
3. “disposable”: false,
4. “dns”: true,
5. “whitelist”: true

As IS STATE:

[MaximeBaker]

Can you show me what is in “Email Results” ?

[ThinhDinh]

You can try feeding that JSON into an AI component and tell it to display formatted JSON.

[MaximeBaker]

I was able to do it with JSONata in query JSON, but I want to make sure my source was like his source.

[ThinhDinh]

@natapi Is this what you want?

[natapi]

here you go…

[natapi]

@ThinhDinh. I ha

ve the JSON with me. I have parsed the JSON through JQ.

[natapi]

@ThinhDinh Glide API is paid :D.

[ThinhDinh]

No, I mean this.

[natapi]

Thanks @ThinhDinh It worked but now I am stuck on getting dynamic values from the Data

[Jeff_Hager]

Change these to point to the appropriate columns.

[natapi]

Hi @Jeff_Hager . I have columns as follows but when I change to appropriate columns still I am not able to get Dynamic Results

[Jeff_Hager]

@MaximeBaker

can use Query JSON column to get each property value in separated columns

@MaximeBaker

I was able to do it with JSONata in query JSON

.

[ThinhDinh]

What exactly is your desired end result? Is it this?