API -> transform pin into request

Hello again,

after working on it for hours I feel defeated…

How in all seven hells do I convert the summary at https://classic.warcraftlogs.com/reports/a6QWy7cHkjNb8hCP#boss=-3&difficulty=0&type=damage-taken&options=4135&pins=2%24Expression%24%23244F4B%24damage%241%240.0.0.Any%240.0.0.Any%24true%240.0.0.Any%24true%240%24and%24auras-gained%240%240.0.0.Any%240.0.0.Any%24true%240.0.0.Any%24true%2426079|785|"Mind%20Control"|"Dominate%20Mind"%24false%24true&by=target into a v1 API request? -.-

Thanks for the help,
Shariva

Aight, just coding a html parser then.

You don’t. Queries are not supported in the API. You have to use expressions. Is the issue that you don’t understand how to write the query as an expression? You want the IN RANGE expression.

Thanks Kihra! Should have been more specific…

I expected https://classic.warcraftlogs.com/reports/a6QWy7cHkjNb8hCP#boss=-3&difficulty=0&type=damage-taken&options=4135&pins=2%24Expression%24%23244F4B%24damage%241%240.0.0.Any%240.0.0.Any%24true%240.0.0.Any%24true%240%24and%24auras-gained%240%240.0.0.Any%240.0.0.Any%24true%240.0.0.Any%24true%2426079|785|“Mind%20Control”|“Dominate%20Mind”%24false%24true&by=target to be equal to https://classic.warcraftlogs.com/reports/a6QWy7cHkjNb8hCP#boss=-3&difficulty=0&type=damage-taken&options=4135&by=target&pins=2%24Off%24%23244F4B%24expression%24NOT%20IN%20RANGE%20FROM%20type%20%3D%20"applydebuff"%20AND%20ability.name%20%3D%20"Cause%20Insanity"%20TO%20type%20%3D%20"removedebuff"%20and%20ability.name%3D"Cause%20Insanity"%20END%20AND%20NOT%20IN%20RANGE%20FROM%20type%20%3D%20"applydebuff"%20AND%20ability.name%20%3D%20"True%20Fulfillment"%20TO%20type%20%3D%20"removedebuff"%20and%20ability.name%3D"True%20Fulfillment"%20END%20AND%20NOT%20IN%20RANGE%20FROM%20type%20%3D%20"applydebuff"%20AND%20ability.name%20%3D%20"Mind%20Control"%20TO%20type%20%3D%20"removedebuff"%20and%20ability.name%3D"Mind%20Control"%20END%20AND%20NOT%20IN%20RANGE%20FROM%20type%20%3D%20"applydebuff"%20AND%20ability.name%20%3D%20"Dominate%20Mind"%20TO%20type%20%3D%20"removedebuff"%20and%20ability.name%3D"Dominate%20Mind"%20END -> but it isn’t, what am I doing wrong?

https://classic.warcraftlogs.com/reports/a6QWy7cHkjNb8hCP#type=damage-taken&options=4135&by=target&view=events&pins=2%24Off%24%23244F4B%24expression%24NOT%20IN%20RANGE%20FROM%20type%20%3D%20"applydebuff"%20AND%20ability.name%20%3D%20"Cause%20Insanity"%20TO%20type%20%3D%20"removedebuff"%20and%20ability.name%20%3D%20"Cause%20Insanity"%20END&fight=40

It’s mostly these events that don’t get filtered while Cause Insanity is in range… (https://classic.warcraftlogs.com/reports/a6QWy7cHkjNb8hCP#fight=40&type=auras&spells=debuffs&ability=26079&source=19&view=events)

I am an idiot… Didn’t specify target.name so the range ended at any Cause Insanity ending.

Thanks for getting me on the right track, enjoy the rest of your day! <3