#SPECIAL! and bgetkey - Working with nested fields and how to go directly to a specific nested field

[Patrick B]

Hi,

I could use some help with using blockspring in google sheets. I use the block "Amazon General Item Lookup" which returns a lot of nested fields.

To get the data which I need (Price) I use the bgetkey function. However, I have to do this several times because the bgetkey will return just another nested field where I again have to use the bgetkey function to extract the next nested field (and so on)

My question is: Is it possible to go directly to the nested field (which is also in another nested field)? So I dont have to use so many columns but can go directly to the nested field I need (in my case that would be "Price", see screenshot above)

Thanks for any advice!

Pat

[Daniel Panel]

Hi Pat, were you able to find a solution to the issue?

I am facing the same problem and it looks like Blockspring's support is non-existant. They have ignored my messages :)

Thanks for any help that you may have!

Daniel

[Daniel Panel]

In case it helps you, I seem to have made it work using nested bGetKey functions.

For example: 

=bGetKey(bGetKey(G3,"OfferSummary"), "TotalNew")

Not sure if this is the best approach (it doesn't look like a "clean" solution), but it gets the job done

Any idea for a better solution is welcome!

p.s.: it would be nice if someone from Blockspring answered questions in this forum ! It's a great tool but there is no support at the moment.

[Ron Kagan]

So, this works for me if I run it like so:

=bgetkey(bgetkey(BLOCKSPRING("find-twitter-user","search_query", BY12),"username"),"id")

This returns the expected value.