Inconsistent JSON Names - Inconsistent Mapping

How do I put everything into one JSOn structure for pricing so that it will for every website work. because some websites have different names for their tiers and because of that when I put in a different url the JSON parsing wont map and get put through to Airtable. Is there a way to put all relevant pricing in one JSON structure so that each time the pricing can be processes for different website.

{
“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”
}
}

Hi, you can use the get function here to get your prices.
You can either set variables for it or you can just call the values right in your airtable module.

Edit 2. I didn’t read correctly at first, you are using chat gpt to transform and parse the data you have endless possibilities . I would make it simple and ask for it to not use the name of the tier and use a number as the key to the JSON for the pricing and give the value with the name and the pricing. I’m sure there’s many ways to do this, this is one way.

This will allow you every time to select pricing 1,2,3,4… and have those values as it looks like you are just storing this data together. You can even ask it to start 1 with the least expensive and +1 for the more expensive.


1 Like