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...
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".
cell a1
=webservice("http://yourapi.com")
Alternatively try this formular to get json and then parse the string
=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.- How do I test this URL you provided? I will ask my boss if he is okay with it, but I am guessing he will not be okay with me providing our API on this forum.
