Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

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