How to export content news via API?

Rain Vaine
Kilo Sage

Hello experts,

We have a request to export content news via API.
When I examine the body of a content news, even though the record can be edited in the table (sn_cd_content_base_list)

RainVaine_0-1771458360527.png


The body of the content news is saved in sn_cd_content_news table.
It seems it is saved in the rich content html column:

RainVaine_1-1771458511324.png


Can you give advice on how to pull that data via via like table rest api?
I am new to content news so I am also not sure on the approach.

Regards,
Vaine

2 REPLIES 2

Santhana Rajhan
Mega Sage

Can you share the API URI & Headers you are using?

Hello,
As I've mentioned I am fairly new to content news and as well with APIs so currently I am investigating with rest api explorer.
This is the current URI that I am checking:

RainVaine_0-1771488338206.png

GET https://devxxxxxx.service-now.com/api/now/table/sn_cd_content_news?sysparm_fields=sys_id%2Csubheadli...

This is the current headers and response:

RainVaine_1-1771488554392.png


As you could see the html tags are included. Please let me know what to do so that I could have my content not include the html tags.
Or any form of advice is appreciated, thank you,

Regards,
Vaine