Identifying a single item - API (GraphQL, Retool)

Hello there @hollyhazeldine,

Using a query like that one will give you multiple items in the response if the board has more than one item:

I am not sure what you other platform is doing exactly, but it does say “currentSourceRow” so I believe it might be selecting a specific item from the board before you access the fields.

If you use the same query in your API Playground, do you see multiple items? If so, you will need to check the configuration on the other platform’s end.

Cheers,
Matias

Thank you so much Matias, this is incredibly helpful!

I do have a follow up question, now I’m attempting to create an item but I can only seem to identify one column of one type at a time (ex. text or long_text) and even if I specify multiple values, it replaces the first text column instead of moving onto the next text column. How can I differentiate/specify which column needs to be filled in based on the given value?

Current (not working) query:
mutation {
create_item (board_id: 123456789, item_name: “{{ projectName.value }}”, column_values: “{"name": "ready 3", "text": "{{ clientEmail.value}} ","long_text": "{{ projectDescription.value}} ","text": "{{ projectDeliverables.value}} "}” ) {
id
}
}

I am not sure I follow @hollyhazeldine,

This is the syntax you can use for what you are trying to do:

mutation {
  create_item(
    board_id: 1234567890
    item_name: "My item"
    column_values: "{\\"text_mkm0kaam\\":\\"Some text\\" ,\\"long_text_mkm0akfe\\":\\"Text for the long text column\\"}"
  ) {
    id
  }
}

You don’t need to pass the name twice. And you need to use backslashes to escape outer quotes 😀