Forum Discussion

Copper Contributor

Mar 08, 2023

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...

BI & Data Analysis

excel

Formulas and Functions

Macros and VBA

calwalker7

Copper Contributor

Mar 24, 2023

peiyezhu I am not sure how to do this. This is what I am getting

peiyezhu

Bronze Contributor

Mar 25, 2023

=webservice("http://e.anyoupin.cn/?s2=select%20%20*%20from%20Second_to_last_value_from_table_with_condition")