How we will implement a CDC with Smartsheets API using python. Is that even possible?

Shikha Bhagat

• What are the key endpoints that you have to query
• Which of them are historical
• Which of them support CDC
• What are the key fields / logic to perform CDC and what parameters do you pass to the API to get CDC data

Brian_Richardson

You will need to pay for the Event Log API availability, it's an addon cost for Smartsheet. Once available you can query List Events endpoint.

See the linked documentation for info on authentication - you can use a token that you generate on your account, or you can use Oauth.

https://smartsheet.redoc.ly/tag/events#operation/list-events

Once you get the data, you can of course do what you want with it to support the reporting that you're looking for. ie save it out to another Smartsheet or to a separate storage db. If you'd like to bulk load it to a Smartsheet sheet then see the Add Row endpoint documentation at the link above (find it under Rows) for the format of the body. Smartsheet can take 500 row adds/updates at a time, so you can see my article below for example Javascript code to "chunk" the data up for addition.

https://community.smartsheet.com/discussion/97621/use-javascript-in-bridge-to-efficiently-import-data-from-an-api#latest