...
https://na12.salesforce.com/services/data/v29.0/sobjects/Contact/describe
Notice that is uses v29.0 not v33.0 that we are (as of today) up to.
You can enter that query into the rest explorer in workbench to see what it does.
...
- Of course you can only use this if you have the APIs enabled (from Professional Edition, if you pay, up to Enterprise, Developer and Ultimate).
- Beware of security. DO NOT LOG INTO EXCEL AS AN ADMINISTRATOR! All of your data is then visible in Excel by anyone who opens up your PC. Use an Integration account that specifically only has read only access to the data you need it to have access to.
- The user remains logged in when you close excel, so it is logged in next time you open excel.
- Attachment object is not supported.
- Of course, this is one of my biggest issues - it keeps people reliant on Excel rather than trusting and using the data in Salesforce.
Next Steps
Please comment below as to how far you have taken Power Query.
If you are a visual person, you might like this series of YouTube videos https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3ohSvgwoHvd0KO8QsQdiK
Or if you like text, then see this series of articles http://markvsql.com/category/decathlon/
Related Articles
| Filter by label (Content by label) | ||||||
|---|---|---|---|---|---|---|
|
...