Discussions

Hey Sasa,

Could you clarify what you mean by "they all look different"?

The first thing that comes to my mind is that you could make a Fetch Page call with the page_id for the FormSubmission record to get all the details about the page they came from.

But maybe I'm misunderstanding your request. In which case, let me know what problem you are trying to solve inside your custom CRM.

Hi Rich,

The difference that I mentioned was the parameter value of the page_id and id from two documents do not match. So my issue is:

1. I couldn't retrieve the page ID for form submissions in the page list.
2. How can I make an API call to obtain the page ID for a single instance? (I only need the page ID of the page where the form was submitted.)
3. How can I use the page ID to retrieve the form submission data?

Hey Sasa,

1. You had a page_id on FormSubmission records that was missing in the List Pages call? Could it be that you have more than 20 Pages and you need to paginate the List Pages call to get to it?
2. Sorry, I am not sure what you mean by "for a single instance". I'm also unsure about: "I only need the page ID of the page where the form was submitted". The page_id on FormSubmission reflect the pages where the submission was performed in. You might also find this guide interesting, detailing the difference between the "Pages" in the UI and how they are shown in the API: https://developers.myclickfunnels.com/docs/filtering-by-page.
3. Do you want to see all FormSubmissions for a specific page? We'll need to add a filter for that. I think this is a good suggestion and an easy change that we can roll out soon.

I realize that some of your questions might stay unanswered. In which case, feel free to share step by step what you are trying to achieve inside of your custom CRM and what calls you are making including the IDs that you are missing. If you want to keep this private, you can also use the ClickFunnels 2.0 support and ask them to redirect your inquiry to the API team, referencing this thread here.

Thank you Rich, actually, I'm not a developer and I have an external developer who is helping me to find a way to accomplish my request.

Maybe it's gonna be easier if I describe the scenario that I wanted so you can provide me with more suitable solutions.

Our company has more than a hundred branches and the landing pages we create either for a single location or multiple locations, and the lead collected through the landing pages will be sent to our CRM automatically and we add identical branch codes in the form title for single branch because we don't need to ask a customer which branch they would like to inquire since it's written in the page content. On the other hand, for multiple locations, we can add identical branch codes in the form field labels, and the data will be sent to a relative branch in the CRM of the user's selection.

Below is the information we collected while we were testing the API. As I mentioned before, my developer told me the "id" and the "page_id" values from both documents seem not to be able to match together (we don't have much data).

I also consulted with your online support the other day. And what I understood is we can only get form submission data but we couldn't know which page this user had filled in with. This is still undoable in ClickFunnels, am I correct?

I'm just desperately trying to figure out a way to make it happen...hope you can understand what I'm trying to explain here.

FORM SUBMISSION.TXT
[
{
"id": 19589065,
"public_id": "ZLoAln",
"contact_id": 284780998,
"workspace_id": 262911,
"page_id": 12706188,
"created_at": "2024-07-05T08:17:06.939Z",
"updated_at": "2024-07-05T08:17:07.231Z",
"data": {
"mobile": "0910881265",
"contact": {
"email": "sasads@worldgymtaiwan.com",
"last_name": "Yeh",
"first_name": "Sa01"
},
"line_id": "sasayeh",
"core_goal": "減肥",
"phone_number": "+886910881265",
"business_type": "Between Startup and 6 Figures A YearBetween Startup and 6 Figures A Year",
"believe_in_john": "no",
"number_one_challenge": "Sasa wants to drink milk tea"
}
},
{
"id": 19589105,
"public_id": "WLxAak",
"contact_id": 284780998,
"workspace_id": 262911,
"page_id": 12706188,
"created_at": "2024-07-05T08:19:11.068Z",
"updated_at": "2024-07-05T08:19:11.158Z",
"data": {
"mobile": "0912 345 678",
"contact": {
"email": "sasads@worldgymtaiwan.com",
"last_name": "Yeh",
"first_name": "Sa02"
},
"line_id": "sasayeh",
"core_goal": "dsasd",
"phone_number": "+886912345678",
"business_type": "Over 6 Figures Per Year",
"believe_in_john": "I'm Not Sure",
"number_one_challenge": "dsa"
}
},
{
"id": 19590342,
"public_id": "mDxDxk",
"contact_id": 284780998,
"workspace_id": 262911,
"page_id": 12718569,
"created_at": "2024-07-05T09:12:34.632Z",
"updated_at": "2024-07-05T09:12:34.706Z",
"data": {
"mobile": "0910881265",
"contact": {
"email": "sasads@worldgymtaiwan.com",
"last_name": "Form 2",
"first_name": "SA1"
},
"line_id": "sdfasdfaa",
"core_goal": "減肥dsas",
"phone_number": "+886910881265",
"business_type": "Over 7 Figures Per Year",
"believe_in_john": "I'm Not Sure",
"number_one_challenge": "sasSasa wants to drink milk tea"
}
},
{
"id": 19590370,
"public_id": "MLeLMp",
"contact_id": 284780998,
"workspace_id": 262911,
"page_id": 12718569,
"created_at": "2024-07-05T09:13:31.060Z",
"updated_at": "2024-07-05T09:13:31.121Z",
"data": {
"mobile": "0912 345 678",
"contact": {
"email": "sasads@worldgymtaiwan.com",
"last_name": "Form 2",
"first_name": "SA2"
},
"line_id": "sasayeh",
"core_goal": "asdf",
"phone_number": "+886912345678",
"business_type": "Over 7 Figures Per Year",
"believe_in_john": "yes",
"number_one_challenge": "dsasasdfas"
}
}
]

PAGE_LIST.TXT

[
{
"id": 12706134,
"public_id": "NWXWKo",
"workspace_id": 262911,
"name": "Example Page",
"created_at": "2024-07-04T09:17:52.615Z",
"updated_at": "2024-07-04T09:17:52.630Z"
},
{
"id": 12706135,
"public_id": "vpmpBD",
"workspace_id": 262911,
"name": "Hero Theme - Blog Home",
"created_at": "2024-07-04T09:17:57.936Z",
"updated_at": "2024-07-04T09:18:26.813Z"
},
{
"id": 12706136,
"public_id": "MrXrqk",
"workspace_id": 262911,
"name": "Hero Theme - Blog Category",
"created_at": "2024-07-04T09:17:57.978Z",
"updated_at": "2024-07-04T09:18:29.117Z"
},
{
"id": 12706137,
"public_id": "kldlqD",
"workspace_id": 262911,
"name": "Hero Theme - Blogs Post",
"created_at": "2024-07-04T09:17:58.023Z",
"updated_at": "2024-07-04T09:18:29.310Z"
},
{
"id": 12706138,
"public_id": "ryryWX",
"workspace_id": 262911,
"name": "Hero Theme - Blog Search",
"created_at": "2024-07-04T09:17:58.063Z",
"updated_at": "2024-07-04T09:18:29.500Z"
},
{
"id": 12706139,
"public_id": "WQXQmB",
"workspace_id": 262911,
"name": "Hero Theme - Checkout",
"created_at": "2024-07-04T09:17:58.105Z",
"updated_at": "2024-07-04T09:18:26.453Z"
},
{
"id": 12706140,
"public_id": "PDqDmw",
"workspace_id": 262911,
"name": "Hero Theme - Collection List",
"created_at": "2024-07-04T09:17:58.144Z",
"updated_at": "2024-07-04T09:18:25.897Z"
},
{
"id": 12706141,
"public_id": "DqXqRb",
"workspace_id": 262911,
"name": "Hero Theme - Collection",
"created_at": "2024-07-04T09:17:58.186Z",
"updated_at": "2024-07-04T09:18:26.079Z"
},
{
"id": 12706142,
"public_id": "mQdQaq",
"workspace_id": 262911,
"name": "Hero Theme - Coming Soon Page",
"created_at": "2024-07-04T09:17:58.231Z",
"updated_at": "2024-07-04T09:18:29.723Z"
},
{
"id": 12706143,
"public_id": "Bnwnxr",
"workspace_id": 262911,
"name": "Hero Theme - Course",
"created_at": "2024-07-04T09:17:58.282Z",
"updated_at": "2024-07-04T09:18:22.504Z"
},
{
"id": 12706144,
"public_id": "xZxZNd",
"workspace_id": 262911,
"name": "Hero Theme - Lesson Page",
"created_at": "2024-07-04T09:17:58.328Z",
"updated_at": "2024-07-04T09:18:25.414Z"
},
{
"id": 12706145,
"public_id": "zVRVMQ",
"workspace_id": 262911,
"name": "Hero Theme - Course Home",
"created_at": "2024-07-04T09:17:58.380Z",
"updated_at": "2024-07-04T09:18:22.703Z"
},
{
"id": 12706146,
"public_id": "RbKbxB",
"workspace_id": 262911,
"name": "Hero Theme - Module Lessons",
"created_at": "2024-07-04T09:17:58.437Z",
"updated_at": "2024-07-04T09:18:23.066Z"
},
{
"id": 12706147,
"public_id": "onvnak",
"workspace_id": 262911,
"name": "Hero Theme - Course Modules",
"created_at": "2024-07-04T09:17:58.491Z",
"updated_at": "2024-07-04T09:18:22.887Z"
},
{
"id": 12706148,
"public_id": "gLdLGR",
"workspace_id": 262911,
"name": "Hero Theme -Customer Center",
"created_at": "2024-07-04T09:17:58.555Z",
"updated_at": "2024-07-04T09:18:22.112Z"
},
{
"id": 12706149,
"public_id": "nnNnan",
"workspace_id": 262911,
"name": "Hero Theme - Home Page",
"created_at": "2024-07-04T09:17:58.620Z",
"updated_at": "2024-07-04T09:18:29.908Z"
},
{
"id": 12706150,
"public_id": "EnbnoX",
"workspace_id": 262911,
"name": "Hero Theme - Member Login",
"created_at": "2024-07-04T09:17:58.701Z",
"updated_at": "2024-07-04T09:18:22.310Z"
},
{
"id": 12706151,
"public_id": "OPXPDb",
"workspace_id": 262911,
"name": "Hero Theme - Page Not Found",
"created_at": "2024-07-04T09:17:58.757Z",
"updated_at": "2024-07-04T09:18:30.183Z"
},
{
"id": 12706152,
"public_id": "GLpLnm",
"workspace_id": 262911,
"name": "Hero Theme - Product",
"created_at": "2024-07-04T09:17:58.811Z",
"updated_at": "2024-07-04T09:18:26.273Z"
},
{
"id": 12706153,
"public_id": "wyBydp",
"workspace_id": 262911,
"name": "Hero Theme - Store Front",
"created_at": "2024-07-04T09:17:58.874Z",
"updated_at": "2024-07-04T09:18:25.712Z"
}
]

Hey Sasa,

Thanks for sharing your use case! I think you are on the right path with solving your problem.

I've spot-checked your workspace, and the page_id of the first FormSubmission that you posted (12706188) belongs to this page:

    {
        "id": 12706188,
        "public_id": "VoXoXL",
        "workspace_id": 262911,
        "name": "Copy of Webinar Thank You -- 30139",
        "theme_id": null,
        "created_at": "2024-07-04T09:24:31.790Z",
        "updated_at": "2024-07-04T10:59:52.784Z"
    }

Your developer should be able to get to it by various means:

• With an extra call to Fetch Page using the page_id from the FormSubmission.
• If you need to use the List Pages endpoint for some reason, please refer to our pagination guide here. Otherwise only 20 records are shown per List call (you currently have a total of 26 visible pages, so it's not visible in your PAGE_LIST.TXT).

Let us know if you run anything and thanks for giving the ClickFunnels API a spin for this!