Adding Data in a CSV to Vendia Share Using Email
(Note, this is Part 1 of our series about Integrating Data Stores with Vendia Share)
In our previous posts we’ve explained why Vendia standardized on GraphQL for Vendia Share to add/edit your shareable data and how Vendia has enhanced the GraphQL developer experience. But what if you need to work with partners that prefer to share their data in a CSV file, and they prefer to send you that file over email?
Don’t worry - Vendia Share can help with that as well.
In real-world use cases, we often see modern data are informed simple (dare we say ‘outdated’?) inputs like CSV or emails. For example, let’s say there was a regular transaction log that could be exported as a CSV that needs to settle with another transaction log. Or let’s say that a tire manufacturer’s ERP creates a daily CSV report of tires and their identification numbers. This information could be uploaded Vendia Share and then used via a track and trace application in order to easily notify owners if those exact tires ever needed to be recalled. And what if that CSV is attached to an email? We can help with that, too.
There are numerous examples partner data sharing in which one partner’s data does not need to be as 'real-time' or as sophisticated as the rest of the partner network - and often the simplest solution, like adding a CSV, is the best solution.
This example will demonstrate how to send scalar data from a comma-separated value (CSV) file to a Vendia Share Uni.
We will deploy the example using the Vendia Share Command Line Interface (CLI) and the AWS Serverless Application Model (SAM) to send scalar data from a CSV to a Vendia Share Uni.
Serverless resources like a AWS S3 bucket and AWS Lambda function will be deployed. CSV processing with a AWS Lambda function will be triggered by uploading data to a AWS S3 bucket. The Lambda function will read through the CSV and publish data to a node's GraphQL endpoint.