Problem with FILTERXML

%3CLINGO-SUB%20id%3D%22lingo-sub-2678766%22%20slang%3D%22de-DE%22%3EProblem%20with%20FILTERXML%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2678766%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%20Guys!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20a%20problem%20with%20the%20FILTERXML%20function.%3C%2FP%3E%3CP%3E(please%20note%20that%20my%20code%20is%20in%20English)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20get%20the%20current%20follower%20amount%20of%20our%20companies%20social%20media%20channels%20with%20the%20FILTERXML-function.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI've%20tried%20it%20insode%20Excel%20%26amp%3B%20Google%20Sheets%2C%20but%20neither%20seems%20to%20work%2C%20also%20with%20X%20path%20%26amp%3B%20full%20x%20path%20%3CBR%20%2F%3E%20Maybe%20there%20is%20someone%20out%20here%20who%20could%20help%20me%20with%20this%20as%20i'm%20completely%20frustrated%20%3CLI-EMOJI%20id%3D%22lia_grinning-face-with-smiling-eyes%22%20title%3D%22%3Agrinning_face_with_smiling_eyes%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Excel%3A%20%3CBR%20%2F%3E%20%3DXMLFILTERN(%22%3CA%20href%3D%22https%3A%2F%2Fwww.instagram.com%2Fskinbaronde%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.instagram.com%2Fskinbaronde%2F%3C%2FA%3E%22%3B%22%20html%2Fbody%2Fdiv%5B1%5D%2Fsection%2Fmain%2Fdiv%2Fheader%2Fsection%2Ful%2Fli%5B2%5D%2Fa%2Fspan%22)%20%3CBR%20%2F%3E%20%26gt%3BResult%3A%20%23Value!%3CBR%20%2F%3E%3CBR%20%2F%3EGoogle%20Sheets%3A%3CBR%20%2F%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3D%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3EIMPORTXML%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E(%3C%2FSPAN%3E%22%3CSPAN%20class%3D%22%20string%20%22%3E%3CA%20href%3D%22https%3A%2F%2Fwww.instagram.com%2Fskinbaronde%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.instagram.com%2Fskinbaronde%2F%3C%2FA%3E%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E%3B%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%20string%20%22%3E%22%2Fhtml%2Fbody%2Fdiv%5B1%5D%2Fsection%2Fmain%2Fdiv%2Fheader%2Fsection%2Ful%2Fli%5B2%5D%2Fa%2Fspan%22%3C%2FSPAN%3E%3CSPAN%20class%3D%22%20default-formula-text-color%22%3E)%3C%2FSPAN%3E%3CBR%20%2F%3E%26gt%3BResult%3A%20%23N%2FA%20Thanks%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2678766%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello Guys!

I have a problem with the FILTERXML function.

(please note that my code is in German)

 

I'm trying to get the current follower amount of our companies social media channels with the FILTERXML-function.


I've tried it insode Excel & Google Sheets, but neither seems to work, also with X path & full x path
Maybe there is someone out here who could help me with this as i'm completely frustrated

Excel:
=XMLFILTERN("https://www.instagram.com/skinbaronde/";"//html/body/div[1]/section/main/div/header/section/ul/li[2]/a/span")
>Result: #Value!

Google Sheets:
=IMPORTXML("https://www.instagram.com/skinbaronde/";"/html/body/div[1]/section/main/div/header/section/ul/li[2]/a/span")
>Result: #N/A

Thanks in advance!

0 Replies