Power Automate http request to Sharepoint error

[rich0087]

I'm creating a flow to using send an http request to Sharepoint and i'm receiving an error when i run a test. My document library is called Training Resource Videos. I've tried various methods but all seems to fail.

The HTTPS Request methods i used were: 

First method: 

_api/getByTitle('Training%20Resource%20Videos')/items?$select=Title,Category,TrainingID,URL,Length,Instructor,LinktoFile,Description

Second: 

_api/web/GetFolderByServerRelativeURL('/Training%20Resource%20Videos')/items?$select=Title,Category,TrainingID,URL,Length,Instructor,LinktoFile,Description

Third:

......sharepoint.com/sites/MCS-DC/_api/web/lists/getbytitle('Training%20Resource%20Videos')/items?$select=Title

I was trying to follow this site as an example: https://www.netwoven.com/2018/12/11/how-to-get-filtered-items-from-sharepoint-list-to-powerapps-usin...

my goal is to be able to build a gallery that will pull all the training resources that is easily searchable and can open the document.

Any  help would be appreciated.

[joeinmay]

The steps explained in the link works perfect and it should give you the desired results, provided you are paying for the Response connector.

The Response connector is a premium connector.

[rich0087]

I have access to the connector. Is my query wrong...or the column names....

_api/getByTitle('Training%20Resource%20Videos')/items?$select=Title,Category,TrainingID,URL,Length,Instructor,LinktoFile,Description