Hello!
I am having a hard time trying to understand how to put or format my response from bigquery to create records and filter views easily.
So far, I know you can only connect to bigquery via API, using GET method you can get this response
So I get the response, that part is fine, then I noticed Appian takes whatever that comes in the body, as the values to use as columns, however, in this case, the values I need, are into the subsection 'rows'
I was able to access that by using .body.rows but that takes me here
which as you see, does not come with column names, so Appian is not able to understand how to put that data into the record type.
Now, I was able to use the input rule on the response, to map to a dictionary and it works:
But then, I get this error on the record type
How can I use my response to be a dictionary, on the record type so that I can work with filters and sync and so on, if my response is coming like that?
Discussion posts and replies are publicly visible
I think that the function createdictionary is a plugin. You will need to remove that.
Instead, you should be able to create the dictionary in a different way.
{ Duckling: fv!item.v[1], . . . }
Wow! That did it, thanks a lot! I think it was hard for me to find this answer as the documentation does not say that this is a plugin, and I did not know how to map my data, you did it man, thanks a lot!!
I seem to remember mentioning something along those lines last week...