API methods

Clan Members

Description Get list of clan members, including TH level and weight (if manually filled)
URL /Clan/CLANTAG/Members.FORMAT
Sample CSV /Clan/LGQJYLPY/Members.csv
Sample JSON /Clan/LGQJYLPY/Members.json
Sample XML /Clan/LGQJYLPY/Members.xml

War Members

Description Get list of clan members in current war
URL /Clan/CLANTAG/WarMembers.FORMAT
Sample CSV /Clan/LGQJYLPY/WarMembers.csv
Sample JSON /Clan/LGQJYLPY/WarMembers.json
Sample XML /Clan/LGQJYLPY/WarMembers.xml

Clan Wars

Description Get list of clan wars
URL /Clan/CLANTAG/Wars.FORMAT
Sample CSV /Clan/LGQJYLPY/Wars.csv
Sample JSON /Clan/LGQJYLPY/Wars.json
Sample XML /Clan/LGQJYLPY/Wars.xml

Clan List

Description Get list of clans
URL /Clans.FORMAT
Sample CSV /Clans.csv
Sample JSON /Clans.json
Sample XML /Clans.xml

Weights

Description Get list of all member weights
URL /Weights.FORMAT
Sample CSV /Weights.csv
Sample JSON /Weights.json
Sample XML /Weights.xml

HOW TO

Import all fields from CSV with IMPORTDATA function

=IMPORTDATA("http://fwastats.com/clan/lgqjylpy/members.csv")

Import one field from XML with IMPORTXML function

=IMPORTXML("http://fwastats.com/clan/lgqjylpy/members.xml";"//Name")

Import any HTML table with IMPORTHTML function

=IMPORTHTML("http://fwastats.com/Clans";"table";1)

Click DATA > From Web

Set address: http://fwastats.com/clan/lgqjylpy/members.xml

Click Go

Click Import

Excel complains about missing schema, click OK

Import data to $A$1, click Go

You can refresh the data or configure automatic refresh on DESIGN tab


This content is not affiliated with, endorsed, sponsored, or specifically approved by Supercell and Supercell is not responsible for it. For more information see Supercellโ€™s Fan Content Policy: www.supercell.com/fan-content-policy. This website uses cookies, more details in Privacy Policy.