Building Queries

[TCGdexBOT]

💬 tishingo on Discord wrote:

I was trying to query regulation marks earlier but It was failing in postman

[TCGdexBOT]

💬 avior on Discord wrote:

any fields from the card should work

[TCGdexBOT]

💬 tishingo on Discord wrote:

how do some of the nested fields work in that case?
like if i wanted to retrieve all legal standard cards and exclude any expanded?

[TCGdexBOT]

💬 avior on Discord wrote:

the API do a non deep search on the subfields

[TCGdexBOT]

💬 avior on Discord wrote:

you can't currently do legal comparaison currently

[TCGdexBOT]

💬 tishingo on Discord wrote:

okay thats fine, i can make it up with the sets.

[TCGdexBOT]

💬 avior on Discord wrote:

this is something that will be added later

[TCGdexBOT]

💬 tishingo on Discord wrote:

i see regulationMark is toplevel, but i get 500 errors when i try searching that way, is that not available either?

https://api.tcgdex.net/v2/en/cards?regulationMark=D

[TCGdexBOT]

💬 avior on Discord wrote:

5xx errors should not happens xd

[TCGdexBOT]

💬 avior on Discord wrote:

that is something on our end

[TCGdexBOT]

💬 tishingo on Discord wrote:

ah okay

[TCGdexBOT]

💬 avior on Discord wrote:

i'm looking into what's happening

[TCGdexBOT]

💬 tishingo on Discord wrote:

i appreciate it. that would be an easier approach to figuring out the standard legal set on my end

[TCGdexBOT]

💬 avior on Discord wrote:

The error was found !

[TCGdexBOT]

💬 avior on Discord wrote:

I'm releasing an pdate with it

[TCGdexBOT]

💬 avior on Discord wrote:

ANNNNDD

[TCGdexBOT]

💬 avior on Discord wrote:

i'll reverve my changes on the server

[TCGdexBOT]

💬 avior on Discord wrote:

and as it's quite late I'll look into it this morning (it's 3AM where I live)

[TCGdexBOT]

💬 tishingo on Discord wrote:

understandable

[TCGdexBOT]

💬 avior on Discord wrote:

thanks for your understanding !
i'll keep you up to date when I will have fixed thoses issues !

[TCGdexBOT]

💬 tishingo on Discord wrote:

thanks i appreciate it

[TCGdexBOT]

💬 tishingo on Discord wrote:

just as a mental note for you, it looks like the changes were reverted and the calls are working again (minus the new ones obv)

[TCGdexBOT]

💬 avior on Discord wrote:

Hey, so it seems that I can't replicate the error 😦 I pushed again the update and added error monitoring at another level so it should catch it in the production build, I also changed how my responses were cached and 400+ errors were cached before 😦 but now they aren't 🙂

[TCGdexBOT]

💬 tishingo on Discord wrote:

maybe it was a deployment fluke?

[TCGdexBOT]

💬 tishingo on Discord wrote:

so is it working now?

[TCGdexBOT]

💬 tishingo on Discord wrote:

Looks like it is.

[TCGdexBOT]

💬 tishingo on Discord wrote:

For anyone who stumbles on this thread, here was my solution for building queries in javascript:

const base_url = 'https://api.tcgdex.net/v2/en/cards';

const validFilters = ['category', 'id', 'illustrator', 'image', 'localId', 'name', 
                    'rarity', 'set', 'variants', 'hp', 'types', 'evolveFrom', 
                    'description', 'stage', 'attacks', 'weaknesses',
                     'retreat', 'regulationMark', 'legal'];

class TCGdexController {
    static async query(filterParams) {
        let queryStr = base_url;
        let queryParams = [];

        for (let filter in filterParams) {
            if (validFilters.includes(filter)) {
                queryParams.push(encodeURIComponent(filter) + '=' + encodeURIComponent(filterParams[filter]));
            }
        }

        if (queryParams.length > 0) {
            queryStr += '?' + queryParams.join('&');
        }

        try {
            const response = await fetch(queryStr);
            if (!response.ok) {
                throw new Error('There was a problem querying the data.');
            }
            let data = await response.json();
            
            // only keep values with an image
            data = data.filter(card => "image" in card);
            return data;
        } catch (error) {
            console.error("Error:", error);
        }
    }
}

export default TCGdexController;

I made it so the filterParams are passed as an object.
Here's an example of a simple case, searching by name:

let filters = { "name": "pikachu" };

a more advanced example would just add additional fields to the object:

let filters = {
  "name": "pikachu",
  "regulationMark" : "D",
  "set" : "vivid voltage"
}

[TCGdexBOT]

💬 cssagogo on Discord wrote:

What would acceptable values for Weaknessess be?

[TCGdexBOT]

💬 cssagogo on Discord wrote:

I've tried various methods, but they all seem to return a blank array:

https://api.tcgdex.net/v2/en/cards?weaknesses=fire

[TCGdexBOT]

💬 avior on Discord wrote:

I'll take a look at it, the filtering system need some tweaks

[AlexSanchezCdz]

If I run the query through a 'legal.standard' URL parameter it works… but I can't get it to work using the SDK queries: query.equal('legal.standard', 'true');