Using Xano to Update Product Prices with an External API

In this meeting, the State Changers discuss a database with products from Amazon. They want to make a request to an external API to update the price. However, they can only send the identifier in batches of ten products at a time. They customize the output of the database query to only include the ID and ACIN columns. They create a new variable called "batch" and loop through the product records, adding each one to the batch variable until it reaches ten items. At that point, they stop and debug to make sure the previous steps worked correctly. They then extract the ASINs from the batch variable and use it in an API request. They encounter an error because the ASINs are in an array and need to be converted into a string using a filter. They update the API request accordingly and test the solution. The State Changers are advised to work through the solution one step at a time, using stop and debug to troubleshoot any issues that arise.

(Source: Office Hours 7/10 )

State Change Members Can View The Video Here

View This Video Now

Join State Change Risk-Free