POST /card/{card-id}/query/{export-format} filter data

Get Help
1

I created a card with the full dump of my database, and now I want to use a combination of the copy endpoint and the POST /card/{card-id}/query/{export-format} to filter data. My goal is to copy my card, apply some filters, download the filtered data, and then delete the new card. Everything works well, except that the card never seems to apply the filters.

I've been monitoring the network tab in the developer tools and can see the parameters being sent, like this:

parameters: [
  {id: "86737d14-3cd3-4ae2-98d8-21f58dade951", type: "category", value: "legal"},
  {id: "37bc7127-de09-4bbe-9fec-c3c5864fe835", type: "date/single", value: null},
  {id: "c2c052f0-6c8d-477f-b3de-8b08cfb1500d", type: "category", value: null},
  {id: "d40a55ec-3ae9-49b1-bda2-1edabe2a1df6", type: "category", value: null},
  {id: "f44a3896-b228-4955-a7d4-a602af2e9710", type: "category", value: null}
]

When I use the filters set in the graphical interface, I can see the parameters being sent correctly and the filters work well. However, when I try to apply them via the API, it doesn’t work.

Do you have any advice on how to make this work?

2

When you say it doesn't work? What happens exactly?

Can you also share the whole request, including parameter and URL

3

this is the comple db card request:

curl ".../api/card/35/query/xlsx" ^
  -H "Accept: application/json, text/plain, */*" ^
  -H "Accept-Language: es-ES,es;q=0.9,en;q=0.8,pt;q=0.7" ^
  -H "Authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOiIxMDkzNjQ0MDEiLCJleHAiOjE3MjQwNzU0MDF9.pCJPKU6Mng61kGnwodGKa-WlUwPVgW8_EIq1cxLpYu0" ^
  -H "Connection: keep-alive" ^
  -H "Content-Type: application/json" ^
  -H "Origin: http://localhost:4200" ^
  -H "Referer: http://localhost:4200/" ^
  -H "User-Agent: Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36" ^
  -H "x-api-key: mb_kmWavw30y3HgAQCP7aiUWyc3HXiPj1HlHprledNda18=" ^
  --data-raw ^"^{^\^"parameters^\^":^\^"^{^}^\^",^\^"format_rows^\^":false^}^" ^
  --insecure

and this ones are for copying and filter the data

curl ".../api/card/35/copy" ^
  -X "POST" ^
  -H "Accept: application/json, text/plain, */*" ^
  -H "Accept-Language: es-ES,es;q=0.9,en;q=0.8,pt;q=0.7" ^
  -H "Authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOiIxMDkzNjQ0MDEiLCJleHAiOjE3MjQwNzU0MDF9.pCJPKU6Mng61kGnwodGKa-WlUwPVgW8_EIq1cxLpYu0" ^
  -H "Connection: keep-alive" ^
  -H "Content-Length: 0" ^
  -H "Content-Type: application/json" ^
  -H "Origin: http://localhost:4200" ^
  -H "Referer: http://localhost:4200/" ^
  -H "User-Agent: Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36" ^
  -H "x-api-key: mb_kmWavw30y3HgAQCP7aiUWyc3HXiPj1HlHprledNda18=" ^
  --insecure

curl ".../api/card/60/query/xlsx" ^
  -H "Accept: application/json, text/plain, */*" ^
  -H "Referer: http://localhost:4200/" ^
  -H "Authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOiIxMDkzNjQ0MDEiLCJleHAiOjE3MjQwNzU0MDF9.pCJPKU6Mng61kGnwodGKa-WlUwPVgW8_EIq1cxLpYu0" ^
  -H "User-Agent: Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36" ^
  -H "x-api-key: mb_kmWavw30y3HgAQCP7aiUWyc3HXiPj1HlHprledNda18=" ^
  -H "Content-Type: application/json" ^
  --data-raw ^"^{^\^"parameters^\^":^{^\^"Ingreso/Egreso Tipo^\^":^\^"Ingreso^\^",^\^"Ingreso/Egreso Legalidad^\^":^\^"Legal^\^"^},^\^"format_rows^\^":false^}^"

the xlsx that i downaload has no filters so is the same on the 2 cards

and this one is using the graphic interface:

curl ".../api/dataset/xlsx?format_rows=false" ^
  -H "Accept: application/json" ^
  -H "Accept-Language: es-ES,es;q=0.9,en;q=0.8,pt;q=0.7" ^
  -H "Connection: keep-alive" ^
  -H "Content-Type: application/x-www-form-urlencoded;charset=UTF-8" ^
  -H "Cookie: metabase.DEVICE=bfd91323-242a-4724-a93c-7364f6cbe6e9; metabase.TIMEOUT=alive; metabase.SESSION=c81f2655-0a65-4ae0-86db-67a52b773fd1" ^
  -H "Origin: http://...." ^
  -H "Referer: http://.../question" ^
  -H "User-Agent: Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36" ^
  --data-raw ^"query=^%^7B^%^22database^%^22^%^3A2^%^2C^%^22type^%^22^%^3A^%^22query^%^22^%^2C^%^22query^%^22^%^3A^%^7B^%^22source-table^%^22^%^3A^%^22card__35^%^22^%^2C^%^22filter^%^22^%^3A^%^5B^%^22contains^%^22^%^2C^%^5B^%^22field^%^22^%^2C^%^22Ingreso^%^2FEgreso+Legalidad^%^22^%^2C^%^7B^%^22base-type^%^22^%^3A^%^22type^%^2FText^%^22^%^7D^%^5D^%^2C^%^22legal^%^22^%^2C^%^7B^%^22case-sensitive^%^22^%^3Afalse^%^7D^%^5D^%^7D^%^2C^%^22middleware^%^22^%^3A^%^7B^%^22js-int-to-string^%^3F^%^22^%^3Atrue^%^2C^%^22userland-query^%^3F^%^22^%^3Atrue^%^2C^%^22add-default-userland-constraints^%^3F^%^22^%^3Atrue^%^7D^%^7D&visualization_settings=^%^7B^%^22column_settings^%^22^%^3A^%^7B^%^7D^%^2C^%^22table.pivot^%^22^%^3Afalse^%^2C^%^22table.pivot_column^%^22^%^3A^%^22Persona+Nombres^%^22^%^2C^%^22table.cell_column^%^22^%^3A^%^22Ingreso^%^2FEgreso+ID^%^22^%^2C^%^22table.columns^%^22^%^3A^%^5B^%^7B^%^22name^%^22^%^3A^%^22Ingreso^%^2FEgreso+ID^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Ingreso^%^2FEgreso+Tipo^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Ingreso^%^2FEgreso+Legalidad^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Ingreso^%^2FEgreso+Fecha^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Ingreso^%^2FEgreso+Hora^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Ingreso^%^2FEgreso+Lugar^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Coordenadas^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Prefectura^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Cuartel+Policial^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Cantidad+Personas^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Persona+ID^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Persona+Nombres^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Apellido+Paterno^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Apellido+Materno^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Nacionalidad^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Edad^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Fecha+Nacimiento^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Tipo+Documento^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Domicilio+Fijo^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Ciudad^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Regi^%^C3^%^B3n^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Pa^%^C3^%^ADs^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Visa+Posee^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Visa+Otorgada+En^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Acompanante^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Estado+Civil^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Genero^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Funcionario+ID^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Grado+Jer^%^C3^%^A1rquico^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Funcionario+Nombres^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Funcionario+Apellidos^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Dotacion^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Instituci^%^C3^%^B3n^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Rol^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Evento+Legal+ID^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Evento+Legal+Ingreso^%^2FEgreso+ID^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Evento+Ilegal+ID^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Evento+Ilegal+Ingreso^%^2FEgreso+ID^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Viaje+ID^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Fecha+Ingreso^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Hora+Ingreso^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Fecha+Salida^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Hora+Salida^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Punto+Ingreso^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Punto+Salida^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Pa^%^C3^%^ADs+Procedencia^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Direcci^%^C3^%^B3n+Pa^%^C3^%^ADs+Procedencia^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Regi^%^C3^%^B3n+Destino^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Ciudad+Destino^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Calidad+Ingreso^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Motivo+Viaje^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22PDI+Control+ID^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22PDI+Control+Cuartel^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22PDI+Control+Fecha^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22PDI+Control+Hora^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Forma+Consulta+PDI^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Fecha+Respuesta+PDI^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Hora+Respuesta+PDI^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Tipo+Respuesta+PDI^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22PDI+Control+Motivo^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22SRCeI+Control+ID^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22SRCeI+Control+Cuartel^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22SRCeI+Control+Fecha^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22SRCeI+Control+Hora^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Forma+Consulta^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Fecha+Respuesta^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Hora+Respuesta^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Grado^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Nombre+Apellido^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22SRCeI+Control+Motivo^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Posee+Impedimento^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Tipo+Impedimento^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^2C^%^7B^%^22name^%^22^%^3A^%^22Observaciones^%^22^%^2C^%^22enabled^%^22^%^3Atrue^%^7D^%^5D^%^2C^%^22table.column_formatting^%^22^%^3A^%^5B^%^5D^%^7D^" ^
  --insecure