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...
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".
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!"
- can you share your CRM web api url?
can u test this?
=webservice("http://e.anyoupin.cn/?s2=select * from Second_to_last_value_from_table_with_condition")
return:
[{"f01":"4","f02":"1","f03":"£12"},{"f01":"1","f02":"1","f03":"£4"},{"f01":"2","f02":"1","f03":"£55"},{"f01":"3","f02":"1","f03":"£1"},{"f01":"4","f02":"1","f03":"£90"},{"f01":"1","f02":"1","f03":"£19"},{"f01":"2","f02":"1","f03":"£6"},{"f01":"3","f02":"1","f03":"£101"},{"f01":"4","f02":"1","f03":"£201"},{"f01":"1","f02":"2","f03":"£99"},{"f01":"2","f02":"2","f03":"£67"},{"f01":"3","f02":"2","f03":"£2"},{"f01":"4","f02":"2","f03":"£108"},{"f01":"1","f02":"2","f03":"£120"},{"f01":"2","f02":"2","f03":"£220"},{"f01":"3","f02":"2","f03":"£47"},{"f01":"4","f02":"2","f03":"£28"}]
I guess your api returm similar info.