Notifications
Clear all
Topic starter
How can I structure all pricing information into a single JSON format that will work across different websites? Some sites use varying names for their pricing tiers, which causes my JSON parsing to fail when I input a different URL, preventing the data from being mapped and sent to Airtable. Is there a method to consolidate all relevant pricing details into one JSON structure, allowing it to be processed consistently for various websites?
json
{
"pricing": {
"Free Trial": {
"price": " Free Trial $0/M",
"features": ["3,000 credits (one-time)", "3 seats", "5,000 knowledge pages", "AI Assistants", "Workflows", "Core Integrations"]
},
"Starter": {
"price": " Starter $127/M",
"features": ["15,000 credits per month", "5 seats", "50,000 knowledge pages", "Unlimited Assistants", "Unlimited Workflows", "All Integrations (Slack, Notion, Sharepoint, …)"]
},
"Teams": {
"price": " Teams $424/M",
"features": ["60,000 credits per month", "10 seats", "150,000 knowledge pages", "Unlimited Assistants", "Unlimited Workflows", "All Knowledge Base Integrations (Slack, Notion, Sharepoint, …)", "Dedicated Slack support", "1h AI Training Session"]
},
"Enterprise": {
"price": "Enterprise Custom",
"features": ["Custom credits per month", "Custom seats", "Custom knowledge pages", "Unlimited Assistants", "Unlimited Workflows", "All Knowledge Base Integrations (Slack, Notion, Sharepoint, …)", "White glove setup and onboarding", "Advanced permission controls", "Single Sign-On (SSO) capability", "Dedicated AI Implementation Expert", "Personalized AI training sessions", "Custom integrations", "Live syncing with connections", "Workflow deployments", "Document Verification AI", "ROI Report"]
}
},
"freeTrial": {
"offers": "Free tier",
"features": ["3,000 credits (one-time)", "3 seats", "5,000 knowledge pages", "AI Assistants", "Workflows", "Core Integrations"]
},
"discounts": "15% discount for yearly billing"
}
Posted : 29/07/2024 11:41 pm
Hello,
You can utilize the get function here to retrieve your pricing details. You have the option to either define variables for this or directly call the values within your Airtable module.
Edit 2: My apologies, I didn't read carefully initially. You are using ChatGPT for data transformation and parsing, which offers extensive possibilities. I would suggest simplifying this by requesting that it does not use the tier names. Instead, use a numerical key for the pricing JSON, providing the value with the name and the corresponding price. I'm confident there are numerous ways to achieve this, and this is just one approach.
This method will enable you to select pricing 1, 2, 3, 4, and so on, using those values. It appears you are storing this data collectively. You could even instruct it to start with '1' for the least expensive option and increment by one for progressively more expensive ones.
Posted : 30/07/2024 9:09 pm