Hi guys,
I have an Excel power query connection to salesforce, and pull/refresh some data into tables in Excel.
Is it possible to alter data in Excel and then upload/export back to salesforce... as in bypassing their interface..? 🙂
Sincerely,
quqdk
Hello,
It has gone several years now since I worked with Salesforce, so my answer is based on what I got to learn back then.
No, Power Query only has the capabilities to fetch data in, not sending it out. But the result from the queries can of course be imported to Salesforce, but it has to be done from within its own interface.
Br,
Anders
Actually, Power Query can send data to an api, but it might not work properly on all API's, as Anders mentioned it was built mainly for reading data, not sending.
If there is any Content in the body of the request, PQ will send a POST request, here is a sample Json content that will be sent:
ResponseData = Web.Contents(YourAPIUrl,[Content=Json.FromValue({"id":1234, "company_name":"AA LTD"})]),
ResponseData will contain the response of the API.
There is no way to select the request type (GET, PUT, POST and so on).
Okay, thanks to both of you 🙂
Good to know, that it's not possible, or in case it is, it's to difficult to do it for me 🙂
