Log In
Register
Home
New Member
December 1, 2021
Offline
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
See Answer
VIP
Trusted Members
December 7, 2016
Offline
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
Answers Post
November 8, 2013
Offline
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).
The following users say thank you to Catalin Bombea for this useful post:
Anders Sehlstedt
1 Guest(s)
