How to fix function syntax error: IMPORTHTML?

M

Margarita Uvarova2021-09-27 14:31:58

Google Sheets

Margarita Uvarova, 2021-09-27 14:31:58

Function syntax error:

=IMPORTHTML("https://iss.moex.com/iss/securities/"&D4&".xml?iss.meta=off&iss.only=boards&boards.columns=secid,is_primary,boardid", "//document//data//rows//row[@is_primary=1]/@boardid"

)

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

G

Grigory Boev, 2021-10-28
@ProgrammerForever

IMPORTHTML only supports a list or table as the second parameter.
You need IMPORTXML

=IMPORTXML("https://iss.moex.com/iss/securities/"&D4&".xml?iss.meta=off&iss.only=boards&boards.columns=secid,is_primary,boardid", "//document//data//rows//row[@is_primary=1]/@boardid")