I am trying to pull a formula through the api,
works fine on a simple formula with a simple list in the formula itself. eg:
but if i have a list, pulled from a table, which is what I will want to do most of the time, it seems to hold an a sort that I can’t figure out. and doesn’t represent what I can see in the coda doc.
the raw json i get back is below
name': 'margin_values', 'value': '0.091,0.083,0.095,0.085'}
I have tried wrapping the formula in a to Text() but doesn’t seem to make a difference.
Does anyone know how a formula is sorted in the API, or how i can force the API to replicate what I can see on screen.
Think i am missing something simple here but brain seems to be mush.