Finding the correct API for Salesforce reports

Getting Started
1

What are you trying to achieve?

Good day, I am new to Make (Current plan - Free) and want to create a flow whereby a repot is used from Salesforce for all records which were changed for the last 5 days. These records is required to be written in an Excel sheet. The number of records can be any number between 2 and 100. The Excel file can be in csv or xlsx and will be used to run an update for a Website in WordPress.
The module which seems the best for now to start in Salesforce is API call.
However, after various attempts to find the correct API in Salesforce, using the Salesforce Inspector, https://effectivelabsupplies.lightning.force.com/lightning/r/Report/00OSr0000013ZtVMAU/, it still comes back to and error 404 - The operation failed with an error. [404] The requested resource does not exist.
Can not get to upload my .JPG files of Scenario 1 & 2.

Steps taken so far

I have started with the Make an API Call, search for the API link in Salesforce, but still getting the error 404. Also read the post on “Salesforce API calls”. The intention is to use Google Sheets module - Clear Row linked to Get Range values linked to Add a row. The reason will be to create a new Sheet every time this Scenario is ran.
I have looked at the Module Salesforce WATCH RECORD FIELDS, but not getting the see all details from a record, only those properties which were changed.

2

Hello @Hannes_Drotsky, I would suspect that Salesforce API requires authentication, hence the 404. I get similar responses when using other than GET requests with Atlassian’s API.

Once the authentication is sorted, are you sure you’re matching the API call expectations like Content-Type and HTTP Methods: GET, POST, DELETE, PATCH, PUT?

Sharing the Salesforce API would help too.