Query by linked records via REST API [Jun 09]

Discord-Discussions
1

:raising_hand_man: Cris Acosta asked

How to query by linked records via REST API?

2

:man_bald: dstala replied

<@724687678511251489> :: for a scenario of country ‘has many’ city relation, you wish to query city information using link present in the country table? is my understanding correct?

you can give us an example otherwise.

3

:raising_hand_man: Cris Acosta replied

How filter for Categoria´s Id?

{

“list”: [

{

“CodAtendLazer”: 2,

“StatusAtendimento”: “5”,

“ModificadoEm”: “2022-04-01 11:09:03”,

“DestinosRead”: {

“CodDestino”: 6,

“Destino”: “Aracaju”

},

“Agente”: “Guilherme Rocha”,

“FaseVendaRead”: {

“CodFase”: 18,

“FaseVenda”: “Atualização de orçamento”

},

“ClientesRead”: {

“CodCliente”: 2,

“IdTipoPessoa”: 0

},

“Nome”: “Aline Marques Labcom”,

“Categoria”: {

“Id”: 2,

“Nome”: “Venda”,

“Comentario”: null,

“CreatedAt”: “2022-06-04 09:32:23”,

“UpdatedAt”: “2022-06-04 09:48:25”,

“CriadoPor”: 1

}

}

}

4

:man_bald: dstala replied

<@724687678511251489> Currently, you can create filter based on ‘primary value’ of a linked record [primary value is the field content that gets displayed on creating a link]. You can configure primary value field by using API/ in UI.

5

:raising_hand_man: Cris Acosta replied

Hi <@857998597474484295> !

I make a field with this.

6

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs