with Go-UPC and Database?
The Go-UPC API allows users to look up products using their UPC (Universal Product Code) to access detailed information like the product name, description, image, and manufacturer. Leveraging Go-UPC within Pipedream empowers you to automate inventory tracking, streamline product data collection, or enhance e-commerce experiences. By integrating this API, you can enrich datasets, trigger actions based on product lookups, and connect this data to countless other services supported by Pipedream.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
go_upc: {
type: "app",
app: "go_upc",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://go-upc.com/api/v1/code/{your_upc_code}`,
headers: {
Authorization: `Bearer ${this.go_upc.$auth.api_key}`,
},
})
},
})
The Database API on Pipedream allows users to execute SQL commands directly within workflows, enabling rich and dynamic data manipulation and storage. It supports PostgreSQL, MySQL, and SQLite, making it a versatile option for managing data across various database systems. With this API, users can perform tasks such as data insertion, querying, updates, and deletions, directly within their automations, facilitating real-time data processing and integration across multiple platforms.
import postgresql from "@pipedream/postgresql";
export default {
props: {
postgresql,
sql: {
type: "sql",
auth: {
app: "postgresql",
},
label: "PostreSQL Query",
},
},
async run({ $ }) {
const args = this.postgresql.executeQueryAdapter(this.sql);
const data = await this.postgresql.executeQuery(args);
return data;
},
};