Snap Pipeline properties

I have an API which I call and I want to filter the API results on the last successful run of the pipeline, i.e. get the records since last successful pipeline run.

Is there Sanp which can show when the pipeline last completed successfully?

If not what is the best was to write a single record to a SQL table to show when the pipeline last ran and the status?

Thanks