SOAP, REST API and password protect macro

[OlivierS]

Hi,

I'm gonna try to pull data into MsExcel using an API.
I have the choice between REST or SOAP, what's best? Any code example somewhere?
Although, to call the API I will need to provide my password in clear. Is there a way to protect (password?) the part of the code running the API?

Thank you