Forum Discussion
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...
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?
I 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?
- https://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".- Yes, 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.
- cell a1
=webservice("http://yourapi.com")
Alternatively try this formular to get json and then parse the string- Whenever I try this without the quotations, I get "There's a problem with this formula". Whenever I try with quotations, I get "#Value!"