Field names in API change from the name of the field, to the field Key for no reason

By: Chris Rutter | Asked: 06/21/2024
ForumsCategory: General questionsField names in API change from the name of the field, to the field Key for no reason
Chris Rutter asked 1 month ago
All of the information below is dummy data   As you can see, halfway through the data seems to change from using the field name, to the field name key.  Is there a setting or something I've missed?      
[
    {
        "id": "55",
        "item_key": "e43u",
        "name": "Geoff Linton",
        "description": {
            "browser": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36",
            "referrer": "https://www.breeez.com/solenis-ald/"
        },
        "ip": "",
        "form_id": "2",
        "post_id": "0",
        "user_id": "1",
        "parent_item_id": "0",
        "is_draft": "0",
        "updated_by": "1",
        "created_at": "2024-06-21T12:16:52.000Z",
        "updated_at": "2024-06-21T12:16:52.000Z",
        "k7k3z": "[email protected]",
        "8836d": "[email protected]",
        "y9ovz": "1 Chapel Quarter Perfet road Amsterdam, London 373083 United States",
        "y9ovz-value": {
            "line1": "1 Chapel Quarter",
            "line2": "Perfet road",
            "city": "Amsterdam",
            "state": "London",
            "zip": "373083",
            "country": "United States"
        },
        "p1tio": "Yes",
        "32zps": "Dalas",
        "zplk6": "TX",
        "4xobq": "Huston",
        "f92i8": "TX",
        "w8hmn": "New York",
        "j9or7": "New York",
        "r81x5": "No",
        "q3eth": "$4,000.00",
        "q3eth-value": "4000",
        "Your name": "Geoff Linton",
        "Your name Value": {
            "First": "Geoff",
            "Last": "Linton"
        },
        "Phone": "33713713037",
        "Company Name": "Perfect Pools",
        "Company Website": "http://perfectpools.com",
        "Name": "James Lint",
        "Name Value": {
            "First": "James",
            "Last": "Lint"
        },
        "How many years have you been trading for?": "3",
        "Destination Phone Number": "13840918178",
        "Email": "[email protected]",
        "Select your services": [
            "Residential Pool Construction",
            "Retail"
        ],
        "Please pick a min of three unique selling points from the below list that best describes the company": [
            "Expertise & Experience",
            "Quality Materials & Equipment",
            "Efficient Project Management",
            "Customer Satisfaction Guaranteed"
        ],
        "Do they offer finance for pools": "Yes",
        "Are they a top 50 pool builder?": "No",
        "Have they won any awards in the last 2 years? For example design, build or service?": "Yes",
        "Please provide details of the award.": "This award",
        "Please select which associations or affiliations that you aligned with": [
            "Pool & Hot Tub Alliance",
            "National Swimming Pool Foundation",
            "Genesis"
        ],
        "Can we use the current images and logos from their website?": "Yes",
        "Text": "",
        "Checkboxes": [
            "Poolife -  Exclusive Pool water care",
            "Baquacil -  Chlorine Free Pool Care",
            "Sirona - Spa water care",
            "Pristine Blue -  Low Chlorine Pool Water Care"
        ],
        "Submit": ""
    }
]
3 Answers
Victor Font answered 1 month ago
Looking at JSON without context doesn't help anything. You said it's API related, but is Formidable generating it or is it raw JSON. What is the API for? Are you connecting to an external site or another Formidable instance? Are you aware that referencing data elements by key rather than ID is a development best practice?
Chris Rutter replied 4 weeks ago

Thanks for the message Victor.
We use Make.com to process Formidable forms in to Salesforce.
I'll post an image of what I see in Make.com

Chris Rutter answered 4 weeks ago
This is an image of the output from the JSON.  
Attachments
Chris Rutter answered 4 weeks ago
This is an image of the output from the JSON.  
Attachments

Making the Best WordPress Plugin even better - Together

Take on bigger projects with confidence knowing you have access to an entire community of Formidable Experts and Professionals who have your back when the going gets tough. You got this!
Join the community
crossarrow-right