Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Parse html response into a table pocketquery

daniel_hedberg October 1, 2018

Is it possible to parse html code into a table? I have the following SQL response 


Page Name

<p> Backend Version: 8.0.0 <br />Frontend Version: 8.0.0 <br />Program Overwrites: 3 <br /> Table Overwrites: 3 </p>

 

I would like to create a pocket query which parses this into an actual table with these as the column names is that possible?

1 answer

0 votes
Felix Grund (Scandio)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 29, 2019

Hi @daniel_hedberg,

Sorry for the late reply. This can be done very well with a converter. It will receive your HTML string and you'll have to create a proper JS object from the HTML. However, it requires some JavaScript programming. More concretely, you'll have to split your HTML string at the <br /> tags and build your result from the fragments. Our documentation on Converters is here. You can find a few Converter examples in our documentation too.

Also, I remember that we've had a similar use case before, so if you're still interested in a solution, I could try to find the respective conversation.

Best, Felix

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events