Forum Discussion
calwalker7
Mar 08, 2023Copper Contributor
POST API
How do I post API from our CRM? We are able to do so on Google Sheets and have tested the API on Postman. I am getting Error message 405 every time I try when using "Get Data" and selecting either "F...
peiyezhu
Mar 08, 2023Bronze Contributor
We are able to do so on Google Sheets
how do you deal it on Google Sheets in detail?
how do you deal it on Google Sheets in detail?
- calwalker7Mar 09, 2023Copper ContributorI am using an add-on called Apipheny. Is it possible to do this with the "Get Data" part of Excel? If not, can I get an add-on like Apipheny?
- peiyezhuMar 10, 2023Bronze Contributorhttps://apipheny.io/
Apipheny?
if so,vba xmlhttp available
https://codingislove.com/http-requests-excel-vba/
https://codingislove.com/excel-json/
the api provids json string,so you can not use "Get Data" and selecting either "From Web" or From "OData Feed".- calwalker7Mar 13, 2023Copper ContributorYes, Apipheny us what I used for Google Sheets. How would i I do this, if I can't "Get Data". It is formatted in JSON.