Deduplicate by Key and Value

How To
1

I would like to deduplicate Collections from Google Sheets based on the criterion that the 1 key and value are the same.

image
image412×830 20.5 KB

[
    {
        "0": "Ruch",
        "1": "Sprzedawca",
        "2": "Produkt",
        "3": "Cena",
        "4": "URL",
        "__ROW_NUMBER__": 1,
        "__SPREADSHEET_ID__": "1orv0dBGro-SOjltqkS0Z2V49SmZJtBOqs_iWXI66uTQ",
        "__SHEET__": "GPLA l Kapcie",
        "__IMTLENGTH__": 5,
        "__IMTINDEX__": 1
    },
    {
        "0": "Płatny",
        "1": "kazda.pl",
        "2": "Sandały w kształcie ryby, kapcie na basen, plażę, pod prysznic, prezent dla wędkarzy, uniseks, dla mężczyzn, kobiet i dzieci2",
        "3": "zł400.00",
        "4": "https://www.amazon.pl/GEQ-sandaly-prysznicowe-w%C4%99dkarzy-m%C4%99%C5%BCczy%C5%BAni/dp/B09SX17DD8?source=ps-sl-shoppingads-lpcontext&ref_=fplfs&psc=1&smid=A3FDCSB9F75MQ7",
        "__ROW_NUMBER__": 2,
        "__SPREADSHEET_ID__": "1orv0dBGro-SOjltqkS0Z2V49SmZJtBOqs_iWXI66uTQ",
        "__SHEET__": "GPLA l Kapcie",
        "__IMTLENGTH__": 5,
        "__IMTINDEX__": 2
    },
    {
        "0": "Płatny",
        "1": "Orto Sklep Medyczny",
        "2": "Sandały w kształcie ryby, kapcie na basen, plażę, pod prysznic, prezent dla wędkarzy, uniseks, dla mężczyzn, kobiet i dzieci2",
        "__ROW_NUMBER__": 3,
        "__SPREADSHEET_ID__": "1orv0dBGro-SOjltqkS0Z2V49SmZJtBOqs_iWXI66uTQ",
        "__SHEET__": "GPLA l Kapcie",
        "__IMTLENGTH__": 5,
        "__IMTINDEX__": 3
    },
    {
        "0": "Płatny",
        "1": "Orto Sklep Medyczny",
        "2": "Kapcie Dr Luigi Granatowe - 36",
        "3": "zł119.00",
        "4": "https://ortosklepmedyczny.pl/produkt/kapcie-dr-luigi-granatowe/?attribute_pa_rozmiar=36&utm_source=Google+Shopping&utm_medium=cpc&utm_campaign=Produktowy",
        "__ROW_NUMBER__": 4,
        "__SPREADSHEET_ID__": "1orv0dBGro-SOjltqkS0Z2V49SmZJtBOqs_iWXI66uTQ",
        "__SHEET__": "GPLA l Kapcie",
        "__IMTLENGTH__": 5,
        "__IMTINDEX__": 4
    },
    {
        "0": "Płatny",
        "1": "Allegro",
        "2": "Ciepłe Kapcie Damskie Skórzane Góralskie Pantofle Wełniane Polskie 35-41",
        "3": "zł51.00",
        "4": "https://allegro.pl/oferta/cieple-kapcie-damskie-skorzane-goralskie-pantofle-welniane-polskie-35-41-16974414534?offerId=16974414534&inventoryUnitId=8skJ5kWZT7Se2QDUkTYbAw&adGroupId=YWY1ZDcyYTMtNThjMS00YmRlLTlmMDctMDBmODE0MzU4NDE3AA&campaignId=NDQ4NzY2YjItOGQ4OS00ZGUxLTkyMGItODA4NjUwODIyMzY4AA&clientId=MTI5MDg0NzI5AA&sig=7aeecdab7ae6b83d78536b1d4f09db36&utm_feed=cba59b59-8d0f-48d0-98a0-e9d1127523e2&utm_source=google&utm_medium=freelisting",
        "__ROW_NUMBER__": 5,
        "__SPREADSHEET_ID__": "1orv0dBGro-SOjltqkS0Z2V49SmZJtBOqs_iWXI66uTQ",
        "__SHEET__": "GPLA l Kapcie",
        "__IMTLENGTH__": 5,
        "__IMTINDEX__": 5
    }
]
2

@PeKA37
Hi, I think the following post is helpful.
It also explains the API Endpoint and Request Body, so if you take a look at it, I think you will find the solution.

3

Thanks, I’ll check if it works :wink:

1 Like