How to fetch product data from a URL

[Nick_Bertha]

Hi I am trying to find a way to fetch and store product data from a URL that users can upload –– similar to the image below. Anyone have ideas on how to do this efficiently? Thanks!

[Darren_Murphy]

It may be difficult to do this reliably, as you have no control over the source, but you can try the following:

• Use a Get Webpage Source column to fetch the URL source.
• Use an AI Text to JSON column to extract the key/value pairs that you need and return as a JSON object.
• Use one or more Query JSON columns to extract the values you need from the JSON object.

[Nick_Bertha]

Thanks I’ll give that a try and let you know how it goes!