We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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