Trello API Custom Fields

[Daniel H]

the api is not returning some custom fields for each card, even though they have data in the field. some fields return data, some return blank even though it should have data. i can’t seem to figure out the pattern of why. here's the api call i'm using

https://api.trello.com/1/boards/.../cards?customFieldItems=true&filter=open&fields=all&key=...&token= ...

thanks for any help!

[Daniel H]

I think I might know what’s going on. It’s because the API will rearrange the custom field depending on if the field is populated or not. So somehow I need to make the blank fields get called up too? Anyone know how to do that?

Example:

Trello Card has field 1, 2, 3, but only 1, 3 have values

API returns 1, 3, but I need 2 so it stays in order on the spreadsheet i'm syncing it to

Another thing that could help is if the fields were labeled/named by the field's name? i don't know how to do that.

[milynnus]

@Daniel H 

Take a look at this

https://github.com/xu2xulim/Superhero/blob/master/Superhero%20on%20deta/Micros/Custom%20Fields.md

[Daniel H]

Thank you for the help. Sorry I'm not very technical, is this something I'm supposed to append my api call with? I would like a way to translate IDs to Names. I'm trying to get Trello to one-way sync with a different database.

[milynnus]

@Daniel H 

Each micro is a collection of api to get to your Trello data or to some services to be performed. In this case, it is to get the custom fields as key:value. 
You can do it with Trello api and for custom fields you need to work with custom field definitions which will give you the name, type, etc. and the custom field values stored on the card. 

[Daniel H]

Thanks again, but I really don't know how to use the link you gave. Am I supposed to input my data into that to get a code I can use to get every card's custom fields and their values?

[milynnus]

@Daniel H 

I have updated the documentation with a price lookup example.