Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
kruzikruz
Regular Visitor

Problem with JSON

hi,

How can I get rid of 3 rows in a table with this JSON schema? Every time I want to expand the adviceAlgorithm list, I get 3 rows in the table even though I have one ID.

 

 

 

{
    "totalCount": 1,
    "advices": [
        {
            "id": "04b50215-d7c9-473a-8b55-0c5077ac696a",
            "company": {
                "id": "c7f6be29-5a64-491e-875b-684ac9aa9db7",
                "name": "FIRMA Sp. Z o.o.",
                "rolePermission": "ROLE_SUPPLIER"
            },
            "gate": {
                "id": "dd957e10-6b76-425d-8127-4f183d0de121",
                "name": "DOK2"
            },
            "warehouse": {
                "id": "172864d1-f107-4308-8d28-c24fc2fd1d76",
                "name": "MAGAZYN H4"
            },
            "dateTimeFrom": "2023-01-09 11:30:00",
            "dateTimeTo": "2023-01-09 12:30:00",
            "duration": 60,
            "durationPresentation": "01:00",
            "timeStart": 690,
            "adviceAlgorithm": [
                {
                    "algorithmField": {
                        "id": "114bd7f8-42b1-4298-84c0-d978f87b8822",
                        "name": "Numer zamowienia",
                        "shortName": "NZ",
                        "variable": 5,
                        "type": "T",
                        "option": [],
                        "optionObj": [],
                        "enableIdenticalValueSearch": false,
                        "enableDeleteUsedValue": false,
                        "enableMultipleValue": false,
                        "minimumNumberSearchCharacters": null
                    },
                    "algorithmFieldValue": "123456789",
                    "algorithmFieldValuePresentation": "123456789"
                },
                {
                    "algorithmField": {
                        "id": "40aa83bd-d5ec-4cf1-8dfe-58a2e3d56438",
                        "name": "Ilość palet",
                        "shortName": "IP",
                        "variable": 1,
                        "type": "N",
                        "option": [],
                        "optionObj": [],
                        "enableIdenticalValueSearch": false,
                        "enableDeleteUsedValue": false,
                        "enableMultipleValue": false,
                        "minimumNumberSearchCharacters": null
                    },
                    "algorithmFieldValue": "33",
                    "algorithmFieldValuePresentation": "33"
                },
                {
                    "algorithmField": {
                        "id": "d3b88db9-3a9d-47f3-93ed-14606b70c632",
                        "name": "Rodzaj palet",
                        "shortName": "RP",
                        "variable": 4,
                        "type": "C",
                        "option": [
                            "037990b3-d030-45bb-a390-e809ba5ff5ac",
                            "f28cc042-593c-43b8-997d-2442455690de"
                        ],
                        "optionObj": [
                            {
                                "id": "037990b3-d030-45bb-a390-e809ba5ff5ac",
                                "variable": 5,
                                "name": "Spiętrowane"
                            },
                            {
                                "id": "f28cc042-593c-43b8-997d-2442455690de",
                                "variable": 6,
                                "name": "Pojedyńcze"
                            }
                        ],
                        "enableIdenticalValueSearch": false,
                        "enableDeleteUsedValue": false,
                        "enableMultipleValue": false,
                        "minimumNumberSearchCharacters": null
                    },
                    "algorithmFieldValue": "f28cc042-593c-43b8-997d-2442455690de",
                    "algorithmFieldValuePresentation": "Pojedyńcze"
                }
            ],
            "shipper": null,
            "driverName": "Jan Kowalski",
            "vehicleNumber": "GD123",
            "phone": null,
            "documentNumber": null,
            "number": "000001009",
            "isFinish": false,
            "description": null,
            "type": "U",
            "typePresentation": "advice.form.unloading",
            "storage": false,
            "status": "5",
            "statusPresentation": "advice.status.finish",
            "statusCarInYard": "2023-01-09 11:27:00",
            "statusInProgress": "2023-01-09 11:30:00",
            "statusFinish": "2023-01-09 11:49:00",
            "diffCarInYardAndDateTimeFrom": "3 minuty",
            "diffInProgressAndFinish": "19 minut",
            "diffDateTimeFromAndInProgress": "0",
            "isFlash": false,
            "isCyclical": false,
            "isDeleted": false
        } 
    ]
}

 

 

 

1 REPLY 1
lbendlin
Super User
Super User

What do you expect to happen instead?  Ignore that array?  Concatenate the values?  Pick the first entry? Pick a random entry?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.