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 5 months 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": ""
    }
]
4 Answers
Victor Font answered 5 months 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 5 months 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 5 months ago
This is an image of the output from the JSON.  
Attachments
Chris Rutter answered 5 months ago
This is an image of the output from the JSON.  
Attachments
Chris Rutter answered 4 months ago
Hi, anyone else got any help on this one? 

 
Victor Font replied 4 months ago

I have no idea what Make.com is nor do I recognize the output structure in the images you provided. Using field keys is development best practice because field IDs can change under certain circumstances. Keys are immutable once they are set. See this: https://formidable-masterminds.com/writing-transportable-code-keys-vs-ids/ or this, https://a.co/d/f9aFZMp

Chris Rutter replied 4 months ago

Hi Victor,
Thanks for this.
I ended up renaming all of the IDs which has solved this issue.

Victor Font replied 4 months ago

Yeah! Good job!

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