Forum Academy Marketplace Showcase Pricing Features

Bug or my mistake? Bubble + Blockspring

Hi,

before I file a bug report. Can you tell me what I am doing wrong or is there something bad with the blockspring block “Amazon General Item lookup”?

What I am doing:

  1. Integrating this simple block:

  1. What I then get is:

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.

http://docs.aws.amazon.com/AWSECommerceService/latest/DG/CHAP_response_elements.html#Amount

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

Can you maybe help?

can you try a function that flat your JSON ?

hey nicolas,

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.

Can I somehow copy the Amazon Block and combine it with the json block in a google spreadsheet or something?

In General, what Are my options? Should I contact the blockspring Team?

So what should I do now? I dont think wanting the price from an existing blockspring block is not something fancy/special

Well you can create your own block, or find an API that returns a flat object and use the API connector.

You’re right, it’s not fancy, so you should be able to build your own block.

What I meant: So, I cant modify the existing Amazon block (with for example the flatten json block)

I don’t think so, but it’s a question for Blockspring

Hi,

so I found out that it is possible to clone and modify a block by putting /code in the url. Paul from Blockspring told me this.
https://open.blockspring.com/pkpp1233/amazon-item-lookup/code

https://open.blockspring.com/jtokoph/flatten-json-object/code

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)?

Hello

Please kindly assist with the question i posted in forum.

Its urgent

Can one of the bubble partners send me a quote for this?

Hi Pat,

I had a similar problem, I needed to flatten a JSON payload so that it could be consumed by a bubble API workflow endpoint.

I started by looking at online tools.

I found this - https://konklone.io/json/

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.

Cheers!