Not all items save to bubble via Backend Workflow API call

I am currently trying to pull all items within an API call via Schedule Workflow on a list in Backend. Then I save each as an entry in a table.

Problem is, 2 out of the 22 never make it. I tried adding a delay but still no luck, not sure what to from here.

The raw data consists of a the following:

<Item>
        <Header>
            <ID>e9c2b45a-6483-466a-ab5d-82556fcee60c</ID>
            <CreationTime>2014-09-11T12:21:53.367-04:00</CreationTime>
            <DeletionTime>0001-01-01T00:00:00</DeletionTime>
            <LastModifiedTime>2014-11-26T10:35:05.087-05:00</LastModifiedTime>
            <LastModifiedBy>Pro_AB0164\Clint Gaetz</LastModifiedBy>
        </Header>
        <ID>e9c2b45a-6483-466a-ab5d-82556fcee60c</ID>
        <Rank>2</Rank>
        <Name>Aftermarket Accessories</Name>
        <ChildCategories>
            <Item>
                <Header>
                    <ID>83148aba-9b97-49d6-9097-b1cc811821be</ID>
                    <CreationTime>2014-09-11T12:21:53.417-04:00</CreationTime>
                    <DeletionTime>0001-01-01T00:00:00</DeletionTime>
                    <LastModifiedTime>2015-01-15T16:31:05.857-05:00</LastModifiedTime>
                    <LastModifiedBy>Pro_AB0164\Clint Gaetz</LastModifiedBy>
                </Header>
                <ID>83148aba-9b97-49d6-9097-b1cc811821be</ID>
                <Rank>1</Rank>
                <Name>Customer Accessories</Name>
            </Item>
        </ChildCategories>
    </Item>

There are 2 child categories 's that specifically never make it into bubble.

In the above Customer Accessories is 1 of those 2 ChildCategories that never saves to bubble.

Could anyone point me in the direction as to why this may be happening?

Are you on new wu plans? Shouldn’t br an issue. But check for privacy rules too.

EDIT:
Just checked your payload, we don’t see actually two child categories item.

Hey @Jici :slight_smile:

I’m not sure what you mean by wu plans. I am on the agency plan myself and the app I am working on is on the Starter plan. I checked Usage and it seems to be well below the thresholds.

There are no privacy rules on the data type.

I am noticing two different “data points” when I Initialize the call within the API Connector. Particularly I am creating records for each in the response. Am I somehow not referencing the right Name based on this?

Can you share the whole raw payload ( scroll down in the API connector response and click on raw)
Actually, what you are showing in the API connector is
A) Not the same thing (level)
B) A different payload from API response according if the childcategories is 1 item or more(list)

Sorry, that was just a snippet. The full payload with the missing ChildCategories are Customer Accessories and Tires & Wheels.

<Item>
        <Header>
            <ID>dc44fe4d-6f73-4909-b425-af1fafd33a13</ID>
            <CreationTime>2014-11-26T10:24:27.493-05:00</CreationTime>
            <DeletionTime>0001-01-01T00:00:00</DeletionTime>
            <LastModifiedTime>2014-11-26T10:24:48.67-05:00</LastModifiedTime>
            <LastModifiedBy>Pro_AB0164\Clint Gaetz</LastModifiedBy>
        </Header>
        <ID>dc44fe4d-6f73-4909-b425-af1fafd33a13</ID>
        <Rank>1</Rank>
        <Name>Tires &amp; Wheels</Name>
        <ChildCategories>
            <Item>
                <Header>
                    <ID>3752075e-d79c-4985-b075-5368afdec998</ID>
                    <CreationTime>2014-11-26T10:27:44.6-05:00</CreationTime>
                    <DeletionTime>0001-01-01T00:00:00</DeletionTime>
                    <LastModifiedTime>2020-05-07T12:01:55.55-04:00</LastModifiedTime>
                    <LastModifiedBy>Pro_AB0164\Clint Gaetz</LastModifiedBy>
                </Header>
                <ID>3752075e-d79c-4985-b075-5368afdec998</ID>
                <Rank>0</Rank>
                <Name>Tires &amp; Wheels</Name>
            </Item>
        </ChildCategories>
    </Item>
    <Item>
        <Header>
            <ID>e9c2b45a-6483-466a-ab5d-82556fcee60c</ID>
            <CreationTime>2014-09-11T12:21:53.367-04:00</CreationTime>
            <DeletionTime>0001-01-01T00:00:00</DeletionTime>
            <LastModifiedTime>2014-11-26T10:35:05.087-05:00</LastModifiedTime>
            <LastModifiedBy>Pro_AB0164\Clint Gaetz</LastModifiedBy>
        </Header>
        <ID>e9c2b45a-6483-466a-ab5d-82556fcee60c</ID>
        <Rank>2</Rank>
        <Name>Aftermarket Accessories</Name>
        <ChildCategories>
            <Item>
                <Header>
                    <ID>83148aba-9b97-49d6-9097-b1cc811821be</ID>
                    <CreationTime>2014-09-11T12:21:53.417-04:00</CreationTime>
                    <DeletionTime>0001-01-01T00:00:00</DeletionTime>
                    <LastModifiedTime>2015-01-15T16:31:05.857-05:00</LastModifiedTime>
                    <LastModifiedBy>Pro_AB0164\Clint Gaetz</LastModifiedBy>
                </Header>
                <ID>83148aba-9b97-49d6-9097-b1cc811821be</ID>
                <Rank>1</Rank>
                <Name>Customer Accessories</Name>
            </Item>
        </ChildCategories>
    </Item>

For the full payload from the API connector:

{
    "body": {
        "ServiceCategories": {
            "Item": [
                {
                    "Header": {
                        "ID": "5977efef-67f6-417c-a562-50097d620a85",
                        "CreationTime": "2013-02-05T15:18:16.957-05:00",
                        "DeletionTime": "0001-01-01T00:00:00",
                        "LastModifiedTime": "2021-12-27T09:51:07.13-05:00",
                        "LastModifiedBy": "Pro_AB0164\\Clint Gaetz"
                    },
                    "ID": "5977efef-67f6-417c-a562-50097d620a85",
                    "Rank": "0",
                    "Name": "Automotive Service",
                    "ChildCategories": {
                        "Item": [
                            {
                                "Header": {
                                    "ID": "76bf0105-0307-471a-aa03-d0c981b3adb2",
                                    "CreationTime": "2013-02-05T15:18:45.547-05:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2014-09-16T10:44:08.47-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Administrator"
                                },
                                "ID": "76bf0105-0307-471a-aa03-d0c981b3adb2",
                                "Rank": "0",
                                "Name": "Oil, Lube & Maintenance Service"
                            },
                            {
                                "Header": {
                                    "ID": "21c2e49b-05f9-4819-abca-c8060a0b4df0",
                                    "CreationTime": "2013-02-05T15:20:09.68-05:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2014-09-16T10:44:08.47-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Administrator"
                                },
                                "ID": "21c2e49b-05f9-4819-abca-c8060a0b4df0",
                                "Rank": "1",
                                "Name": "Accessories (Gauges, Power Accessories, Vision & Air Bag)"
                            },
                            {
                                "Header": {
                                    "ID": "512d2cb2-8a28-4c35-a281-c441b637dc61",
                                    "CreationTime": "2013-05-09T15:10:55.92-04:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2014-09-16T10:44:08.47-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Administrator"
                                },
                                "ID": "512d2cb2-8a28-4c35-a281-c441b637dc61",
                                "Rank": "2",
                                "Name": "Batteries"
                            },
                            {
                                "Header": {
                                    "ID": "f83b771f-3530-456c-a475-f2ea47468d56",
                                    "CreationTime": "2013-02-05T15:21:29.667-05:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2023-08-25T08:10:38.31-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Rui Martins"
                                },
                                "ID": "f83b771f-3530-456c-a475-f2ea47468d56",
                                "Rank": "3",
                                "Name": "Brakes"
                            },
                            {
                                "Header": {
                                    "ID": "f9bcdcca-0085-4e59-b04d-38eb1278d63d",
                                    "CreationTime": "2013-02-05T15:21:38.747-05:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2014-09-16T10:44:08.47-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Administrator"
                                },
                                "ID": "f9bcdcca-0085-4e59-b04d-38eb1278d63d",
                                "Rank": "4",
                                "Name": "Cooling System"
                            },
                            {
                                "Header": {
                                    "ID": "9afcb089-f506-428e-b1b8-c169f3d308e1",
                                    "CreationTime": "2013-02-05T15:22:49.883-05:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2014-09-16T10:44:08.47-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Administrator"
                                },
                                "ID": "9afcb089-f506-428e-b1b8-c169f3d308e1",
                                "Rank": "5",
                                "Name": "Driveability (Fuel, Ignition & Emission Systems)"
                            },
                            {
                                "Header": {
                                    "ID": "70cefb97-6051-42ea-b9a3-dfc0967f14d8",
                                    "CreationTime": "2013-02-05T15:23:56.8-05:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2014-09-16T10:44:08.47-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Administrator"
                                },
                                "ID": "70cefb97-6051-42ea-b9a3-dfc0967f14d8",
                                "Rank": "6",
                                "Name": "Drive Train (Final Drive, Transaxle, Differential & Transfer Case)"
                            },
                            {
                                "Header": {
                                    "ID": "dbe8efee-e9ec-46f8-aebe-8efa2d052f16",
                                    "CreationTime": "2013-02-05T15:23:09.453-05:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2014-09-16T10:44:08.47-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Administrator"
                                },
                                "ID": "dbe8efee-e9ec-46f8-aebe-8efa2d052f16",
                                "Rank": "7",
                                "Name": "Electrical (Belts, Lighting, Starting & Charging Systems)"
                            },
                            {
                                "Header": {
                                    "ID": "7b43fbca-6119-423d-8f88-0946b7cb1ff3",
                                    "CreationTime": "2013-02-05T15:23:18.47-05:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2014-09-16T10:44:08.47-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Administrator"
                                },
                                "ID": "7b43fbca-6119-423d-8f88-0946b7cb1ff3",
                                "Rank": "8",
                                "Name": "Engine"
                            },
                            {
                                "Header": {
                                    "ID": "6a4895f1-c6b5-4ef1-bd88-074e8ce0d380",
                                    "CreationTime": "2013-02-05T15:23:25.51-05:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2014-09-16T10:44:08.47-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Administrator"
                                },
                                "ID": "6a4895f1-c6b5-4ef1-bd88-074e8ce0d380",
                                "Rank": "9",
                                "Name": "Exhaust"
                            },
                            {
                                "Header": {
                                    "ID": "077cc3fb-1681-473f-adf1-51195763315d",
                                    "CreationTime": "2013-02-05T15:21:19.997-05:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2014-09-16T10:44:08.47-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Administrator"
                                },
                                "ID": "077cc3fb-1681-473f-adf1-51195763315d",
                                "Rank": "10",
                                "Name": "HVAC (Heating, Ventilation & Air Conditioning)"
                            },
                            {
                                "Header": {
                                    "ID": "56452ac8-1023-4489-b91e-81ea66f41b58",
                                    "CreationTime": "2013-05-23T10:39:06.407-04:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2014-10-14T18:29:41.44-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Administrator"
                                },
                                "ID": "56452ac8-1023-4489-b91e-81ea66f41b58",
                                "Rank": "11",
                                "Name": "Inspections & Certificates"
                            },
                            {
                                "Header": {
                                    "ID": "ff0eeed1-f48f-49ef-b761-c838f233b575",
                                    "CreationTime": "2013-02-05T15:24:08.98-05:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2014-09-16T10:44:08.47-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Administrator"
                                },
                                "ID": "ff0eeed1-f48f-49ef-b761-c838f233b575",
                                "Rank": "12",
                                "Name": "Steering & Suspension"
                            },
                            {
                                "Header": {
                                    "ID": "4f505c5a-74a7-45c6-856e-a654f03c7ceb",
                                    "CreationTime": "2013-02-05T15:24:44.623-05:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2014-09-16T10:44:08.47-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Administrator"
                                },
                                "ID": "4f505c5a-74a7-45c6-856e-a654f03c7ceb",
                                "Rank": "13",
                                "Name": "Sublet & Towing"
                            },
                            {
                                "Header": {
                                    "ID": "b9783dd3-a01e-4b48-8e89-fa2719c80815",
                                    "CreationTime": "2013-02-05T15:24:33.78-05:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2016-10-11T12:08:24.207-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Wolfgang Kukowski"
                                },
                                "ID": "b9783dd3-a01e-4b48-8e89-fa2719c80815",
                                "Rank": "14",
                                "Name": "Transmission & Clutch"
                            },
                            {
                                "Header": {
                                    "ID": "e7e49823-ba48-4831-87a8-8d29654c3199",
                                    "CreationTime": "2014-03-07T12:47:22.23-05:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2016-10-11T12:08:24.207-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Wolfgang Kukowski"
                                },
                                "ID": "e7e49823-ba48-4831-87a8-8d29654c3199",
                                "Rank": "15",
                                "Name": "Cash / Counter Sales"
                            },
                            {
                                "Header": {
                                    "ID": "7c1d890d-9e7a-47b5-9d30-6043a1b718cb",
                                    "CreationTime": "2016-10-11T12:08:08.477-04:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2016-10-11T12:08:24.207-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Wolfgang Kukowski"
                                },
                                "ID": "7c1d890d-9e7a-47b5-9d30-6043a1b718cb",
                                "Rank": "16",
                                "Name": "Parts OTC"
                            },
                            {
                                "Header": {
                                    "ID": "4f21331c-19cb-4a25-b7ec-d3812e6f9a4f",
                                    "CreationTime": "2019-10-10T19:01:16.69-04:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2019-10-10T19:01:04.593-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Clint Gaetz"
                                },
                                "ID": "4f21331c-19cb-4a25-b7ec-d3812e6f9a4f",
                                "Rank": "17",
                                "Name": "Quick Checks / Requests"
                            },
                            {
                                "Header": {
                                    "ID": "728baf2e-b1d6-4f53-bc32-f84d8e016d2b",
                                    "CreationTime": "2023-08-10T12:24:19.983-04:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2023-08-25T08:06:31.13-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Rui Martins"
                                },
                                "ID": "728baf2e-b1d6-4f53-bc32-f84d8e016d2b",
                                "Rank": "2147483647",
                                "Name": "BG Services"
                            }
                        ]
                    }
                },
                {
                    "Header": {
                        "ID": "dc44fe4d-6f73-4909-b425-af1fafd33a13",
                        "CreationTime": "2014-11-26T10:24:27.493-05:00",
                        "DeletionTime": "0001-01-01T00:00:00",
                        "LastModifiedTime": "2014-11-26T10:24:48.67-05:00",
                        "LastModifiedBy": "Pro_AB0164\\Clint Gaetz"
                    },
                    "ID": "dc44fe4d-6f73-4909-b425-af1fafd33a13",
                    "Rank": "1",
                    "Name": "Tires & Wheels",
                    "ChildCategories": {
                        "Item": {
                            "Header": {
                                "ID": "3752075e-d79c-4985-b075-5368afdec998",
                                "CreationTime": "2014-11-26T10:27:44.6-05:00",
                                "DeletionTime": "0001-01-01T00:00:00",
                                "LastModifiedTime": "2020-05-07T12:01:55.55-04:00",
                                "LastModifiedBy": "Pro_AB0164\\Clint Gaetz"
                            },
                            "ID": "3752075e-d79c-4985-b075-5368afdec998",
                            "Rank": "0",
                            "Name": "Tires & Wheels"
                        }
                    }
                },
                {
                    "Header": {
                        "ID": "e9c2b45a-6483-466a-ab5d-82556fcee60c",
                        "CreationTime": "2014-09-11T12:21:53.367-04:00",
                        "DeletionTime": "0001-01-01T00:00:00",
                        "LastModifiedTime": "2014-11-26T10:35:05.087-05:00",
                        "LastModifiedBy": "Pro_AB0164\\Clint Gaetz"
                    },
                    "ID": "e9c2b45a-6483-466a-ab5d-82556fcee60c",
                    "Rank": "2",
                    "Name": "Aftermarket Accessories",
                    "ChildCategories": {
                        "Item": {
                            "Header": {
                                "ID": "83148aba-9b97-49d6-9097-b1cc811821be",
                                "CreationTime": "2014-09-11T12:21:53.417-04:00",
                                "DeletionTime": "0001-01-01T00:00:00",
                                "LastModifiedTime": "2015-01-15T16:31:05.857-05:00",
                                "LastModifiedBy": "Pro_AB0164\\Clint Gaetz"
                            },
                            "ID": "83148aba-9b97-49d6-9097-b1cc811821be",
                            "Rank": "1",
                            "Name": "Customer Accessories"
                        }
                    }
                },
                {
                    "Header": {
                        "ID": "1a54d35e-62b9-4ed3-8a2e-b7bf2ef73a8a",
                        "CreationTime": "2014-09-11T12:21:53.367-04:00",
                        "DeletionTime": "0001-01-01T00:00:00",
                        "LastModifiedTime": "2014-11-26T10:35:05.087-05:00",
                        "LastModifiedBy": "Pro_AB0164\\Clint Gaetz"
                    },
                    "ID": "1a54d35e-62b9-4ed3-8a2e-b7bf2ef73a8a",
                    "Rank": "3",
                    "Name": "Trailer Services",
                    "ChildCategories": {
                        "Item": {
                            "Header": {
                                "ID": "4224059d-3f99-4f9c-8560-04351fe776c1",
                                "CreationTime": "2014-09-11T12:21:53.43-04:00",
                                "DeletionTime": "0001-01-01T00:00:00",
                                "LastModifiedTime": "2014-10-21T17:03:54.883-04:00",
                                "LastModifiedBy": "Pro_AB0164\\Administrator"
                            },
                            "ID": "4224059d-3f99-4f9c-8560-04351fe776c1",
                            "Rank": "1",
                            "Name": "Trailer Services"
                        }
                    }
                },
                {
                    "Header": {
                        "ID": "551ff599-1de9-4570-83d8-83ce0be3813a",
                        "CreationTime": "2014-09-11T12:21:53.367-04:00",
                        "DeletionTime": "0001-01-01T00:00:00",
                        "LastModifiedTime": "2014-11-27T13:12:49.83-05:00",
                        "LastModifiedBy": "Pro_AB0164\\Clint Gaetz"
                    },
                    "ID": "551ff599-1de9-4570-83d8-83ce0be3813a",
                    "Rank": "4",
                    "Name": "Staff, Family & Friend Sales",
                    "ChildCategories": {
                        "Item": [
                            {
                                "Header": {
                                    "ID": "fa610edf-78fb-422f-a06e-f768476026c7",
                                    "CreationTime": "2014-09-11T12:21:53.43-04:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2014-11-27T13:13:08.05-05:00",
                                    "LastModifiedBy": "Pro_AB0164\\Clint Gaetz"
                                },
                                "ID": "fa610edf-78fb-422f-a06e-f768476026c7",
                                "Rank": "0",
                                "Name": "Staff"
                            },
                            {
                                "Header": {
                                    "ID": "5d831728-821b-4e63-ab8e-afd6e7ed8121",
                                    "CreationTime": "2014-09-11T12:21:53.43-04:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2014-11-27T13:13:08.05-05:00",
                                    "LastModifiedBy": "Pro_AB0164\\Clint Gaetz"
                                },
                                "ID": "5d831728-821b-4e63-ab8e-afd6e7ed8121",
                                "Rank": "1",
                                "Name": "Friends"
                            },
                            {
                                "Header": {
                                    "ID": "e70f5f08-7380-42e3-bc3e-d7939d16a705",
                                    "CreationTime": "2014-09-11T12:21:53.43-04:00",
                                    "DeletionTime": "0001-01-01T00:00:00",
                                    "LastModifiedTime": "2014-10-21T17:03:13.853-04:00",
                                    "LastModifiedBy": "Pro_AB0164\\Administrator"
                                },
                                "ID": "e70f5f08-7380-42e3-bc3e-d7939d16a705",
                                "Rank": "2",
                                "Name": "Family"
                            }
                        ]
                    }
                }
            ],
            "_attributes": {
                "xmlns:xsi": "http://www.w3.org/2001/XMLSchema-instance",
                "xmlns:xsd": "http://www.w3.org/2001/XMLSchema"
            }
        }
    },
    "headers": {
        "server": "nginx",
        "date": "Mon, 29 Apr 2024 22:08:39 GMT",
        "content-type": "application/json",
        "connection": "keep-alive",
        "cache-control": "no-cache",
        "pragma": "no-cache",
        "expires": "-1",
        "x-aspnet-version": "4.0.30319",
        "x-powered-by": "ASP.NET"
    }
}

So the problem is (for my point of view) a bad JSON structure from the API provider.
You can see that if there’s more than 1 child category, the encoding will be an array like:

"ChildCategories": {
                    "Item": [

Square brackter after item is the start of an array.
But if there’s only 1 item the API will only show the object, without array like:

"ChildCategories": {
                    "Item": {

There’s some solution for that.
Easiest is change your Schedule API Workflow on a list data type for “TEXT”
The list of text will be ChildCategories item's each item name:merged with ChildCategories's item name
The name field will be set to “This text”

1 Like

@Jici YOU ARE AN ABSOLUTE WIZARD. It worked!!!

One thing to ask, how to did merging ChildCategories item's each item name:merged with ChildCategories's item name work? Is it because of the 2 Names shown here?

Yes exactly and the reason is the one I explained in my previous post.

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.