WHERE is “Offer Summary” and/or LowestNewPrice" (s. 1st screenshot) now?
So, I got other fields (as for example TotalNew, which is the amount of items listed) to work. So I get the data to pull in general. It is working fine. But I cant seem to find the fields I need.
Thank you!
PS. Forgot this:
TotalNew = The total number of new items for sale.
TotalUsed = The total number of used items for sale.
totaloffers = The total number of used items for sale.
Blockspring usually flattens objects, but it seems this one isn’t. unfortunately, we only support flat objects. Can you find another block that returns a flat object?
I could not find another block where I can get the price…without the price information my app would be useless. Is there a way you could get it to work? Or can you maybe help to find at least a workaround for now? I would really appreciate it. I am planning another app at the moment where I would need blockspring and amazon price information too.
Or did anybody else use figure out how to get the price info?
Since you already helped last time in the other amazon+blockspring post: @pasaiidesign
thanks for the input! Unfortunatelly, I am a “nocoder” in in the truest sense of the word…
Do you know if I can modify the “amazon general item lookup” block directly and add the flatten-josen-object? Or how would I go about this…?
Fair enought, I forgot that we’ve to call one single blockspring fonction, so if you use a template block from blockspring, that won’t work.
I don’t know about Amazon API. You may need a developer to create a block which flats your JSON response.
I know I probably sound ridicoulous to everybody who knows about coding…but how can I now modify the amazon-item-lookup block and flatten the price information (with for example to flaten-json-object block)?
Essentially, it flattens the JSON into CSV and worked pretty well with nested JSON’s. Obviously, this is good as a one time, but cannot scale for a process.
I then tried using Zapier with Google Sheets. Use a “Zap” to flatten the incoming JSON, update each line as a separate Google Sheet row. Use another “Zap” to send this update to my bubble endpoint.
It worked - sort of. I was having issues with how Zapier was defining the JSON keys. More importantly, this implementation was not clean. I was basically using Google Sheets as a temporary database.
In the end, I chanced upon - https://flow.built.io/login. It is integration platform, with drag and drop capabilities to define your flow. They have “code blocks” called “activities” with which you can build your flow. For example, they have an activity called “JSON to CSV” and another called “HTTPS Request”. Combining these two did the trick for me. Also, in the long term, I think it is easily configurable and scalable.
Of course, it means learning yet another platform. It took me a couple of weeks to figure it out, but their customer support (through live chat) is amazing. For my use case this was a good fit.
