AWS Integration

  • We have data (csv) that resides in an S3 amazon bucket. What is the best way to integrate the data into our wordpress site/page? I did one manually to show how it should look.

    https://longcandlesticks.com/daily-setups

    Seems like we have a couple of options: invoking the S3 API or setting up an API Gateway on the webserver. Is their a plugin that can accomplish this?

    We want the AWS data to automatically be pulled into wordpress each day around 5:30pm after processing finishes.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator bcworkz

    (@bcworkz)

    It seems searching “amazon s3” yields plugins mostly that save data to AWS, not fetch data. None the less, examining their source code could be useful guidance in your own efforts towards developing a solution.

    I don’t see the need for a gateway, I think using the S3 API would be adequate to fetch the needed data. You can schedule tasks to run using wp_schedule_event(). You can use the WP_Http class to make API requests. You can use fgetcsv() to parse one line of CSV data at a time, placing the data into a PHP array. Once in array form, PHP can easily process the data as needed.

    Thread Starter titanwp

    (@titanwp)

    My plugin search yielded results for using Amazon S3 as a CDN, but that’s not what we need as we already have a content delivery network.

    We need a solution to import our data from our AWS bucket into our wordpress site to be displayed in table format like on https://longcandlesticks.com/daily-setups

    Was just wondering if anyone knew of a (premium) plugin to do this. Sounds like it will all need to be custom.

    Appreciate your feedback and I will look into your suggestions. Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘AWS Integration’ is closed to new replies.