Check this out: API using excel
Your endpoint should be: https://{ your server url }/api
https://{ your server url }/api