CODEWITHSUNDEEP
xmlgoogle-apigoogle-sheets
ivanz
ivanz

Reputation: 815

import XML in google spreadsheet

I have one question/problem I have some xml. Example:

api.mysite.net/xml/user/id/1145

now, i would like to get this 1145 from my sheet. It should look like:

=ImportXML("http://api.mysite.net/xml/user/id/C5"; "/*")

In c5, there would be id :) Thank You

Upvotes: 1

Views: 1084

Answers (1)

Henrique G. Abreu
Henrique G. Abreu

Reputation: 17752

Just use the & to concatenate the strings, e.g.

=ImportXML("http://api.mysite.net/xml/user/id/"&C5; "/*")

Upvotes: 4

Related Questions