Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

TBACustom still broken (or am I using it wrong)? #12

Open
omgrobots1 opened this issue Mar 20, 2019 · 1 comment
Open

TBACustom still broken (or am I using it wrong)? #12

omgrobots1 opened this issue Mar 20, 2019 · 1 comment

Comments

@omgrobots1
Copy link

omgrobots1 commented Mar 20, 2019

I'm trying to get the awards a team has won in the past, so I'm accessing team/frc1351/awards and trying to get the award_type value.
when I use "=TBACustom(TO_TEXT(E4))" (E4 is path above), I get the full JSON file, but "=TBACustom(TO_TEXT(E4),"award_type")" produces a blank/empty cell.
Am I doing something wrong?

edit: =TBACustom(TO_TEXT(E4), "0", "award_type") works, but =TBACustom(TO_TEXT(E4), "0", "award_type","1","award_type") doesn't

@Eiim
Copy link
Owner

Eiim commented Mar 23, 2019

https://www.thebluealliance.com/api/v3/team/frc1351/awards returns a JSON array, so you first must select which index in the array you're attempting to access, such as =TBACustom(TO_TEXT(E4),0,"award_type"). If this still doesn't work, let me know.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants