Last Updated then Import (REST API)

[Alex Ward]

Hi All,

I'm looking to identify the best way to import knowledge from confluence to ServiceNow.

My current thoughts on the approach is to make a REST API call to get the content of a space. Based on the response I would then like to identify any content that has been updated that day, then with the ID of those make additional REST API calls to extract the data needed to create a Knowledge article in ServiceNow.

I don't however think I have the right Endpoint I need to perform the initial task of getting any content updated that day.

Does anyone have any tips and or tricks that may assist me?

I been using the Confluence REST API Documentation as a point of reference. I am getting 200 responses and can see content, but this is everything from the space, not just updated today.

https://<domain>.atlassian.net/wiki/rest/api/space/TO/content?expand=history,lastUpdated

[Pramodh M · Accepted solution]

@Alex Ward 

Welcome to the community 🙂

Instead of updates you could check revision of page

https://developer.atlassian.com/cloud/confluence/rest/api-group-content/#api-wiki-rest-api-content-id-get

Or we have content history api as well

https://developer.atlassian.com/cloud/confluence/rest/api-group-content/#api-wiki-rest-api-content-id-history-get

Let me know your thoughts on the API

Thanks,

Pramodh

[Alex Ward]

Thank you for your suggestions. I will take a look, have a play and mark as correct if this does the job.

[Alex Ward]

Hello Pramodh,

I'm now attempting to perform the look up using the Search API, but i'm not sure I have the CQL syntax correct.

In the example on this page the query is run using %20 to replace white space.

However when I am looking at the CQL field reference page the examples are shown with white space, not %20.

What would be the correct syntax for running these CQL queries?