How do we expand table fields in API integration

We followed the steps to expand the table fields in the Table e.g. First Name, Last Name appeared as Name... so we expanded and now there is a column for First Name and a column for Last Name.

But we have a data integration and First Name, Last Name just comes through as Name with first and last name concatenated.

How do we expand so the data flows as First Name and Last Name in separate fields?

Hi LAGOS,

Thanks for reaching out to Jotform Support. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

Regarding your question about expanding table fields in API integration so that First Name and Last Name flow as separate fields instead of a concatenated Name, here is what you need to know:

In Jotform Tables, when you expand a column like Name into subfields such as First Name and Last Name, this change is reflected within the Table interface. However, during API integration, the data may still come through as a single concatenated field if the API request or integration setup does not specifically map or request the expanded subfields separately.

To have First Name and Last Name flow as separate fields via API, you need to ensure your integration or API call explicitly requests or maps these individual subfields rather than the combined Name field. This might involve adjusting your API payload or the integration settings to target the expanded columns.

If your integration tool or custom code is only pulling the combined Name field, you will need to modify it to access the expanded columns for First Name and Last Name separately.

Give it a try and let us know how it goes.

Please provide a sample of the formatting for explicitly calling the subfields in an API call.

Hi LAGOS,

To explicitly call the subfields like First Name and Last Name in your API call, you need to reference the expanded columns directly in your API request payload or integration mapping. Instead of using the combined "Name" field, use the exact column names for "First Name" and "Last Name" as they appear in your Jotform Table after expansion.

This means your API call should target these separate fields explicitly to receive the data in distinct parts.

Hi LAGOS,

Thanks for reaching out to Jotform Support. The format in which data is provided via the API cannot be changed. The Name field will continue to deliver the first and last names concatenated. To ensure you receive First Name and Last Name separately, we recommend using Short Text fields instead of the built-in Name field when designing your form. This will allow the API to return distinct values for each entry.

Let us know if there’s anything else we can help you with.