Import fields duplicate

[anaxoras]

I do not why it is importing the last field duplicated: This is the url that it is importing: https://app.thebookingbutton.com/api/v1/properties/hpdidirect/rates.json? Where you can see the last date is date: "2018-11-25" But in the google spreadsheets yo can see in raws 16 and 17 that the date is duplicated. The formula is: =(ImportJSON("https://app.thebookingbutton.com/api/v1/properties/hpdidirect/rates.json?&start_date=2018-11-12",)) Am I doing something wrong ? Thanks, Alejandro

[jarrodm08]

I think i came across a similar issue - I'm not particularly versed in coding but from my findings, I think this has to do with some time of overload. For example, if normally you have a "room type name" entry, but it contains multiple "things" within it, it tries to spit the date out for everything inside. Likely meaning, whatever this is from, likely produces two "things" in a single entry, causing it to produce two of the same date (bc they were likely created simultaneously)

[imdkbj]

I am facing same issue as last row is duplicated in JSON downloaded from URL - https://nseindia.com/live_market/dynaContent/live_watch/stock_watch/foSecStockWatch.json

This issue is not present in old version:- https://gist.github.com/paulgambill/cacd19da95a1421d3164

[dwolff22]

I have recently observed duplicates lines being created as well. I'm hoping that someone can shed some light on this. The URL and a screen shot are provided. Any assistance/explanation is appreciated.

https://rest.bandsintown.com/artists/Dan%20Wolff/events?app_id=test

[zenminimalist]

Same issue when I import for e.g. =importJSON("https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=netSharePurchaseActivity") On every tab, new speadsheet I open - no matter what.

But, here's the twist: If I open a new spreadsheet with a different Google account with importJSON I do NOT get that issue. It just recently poped up. I can't seem to narrow it down-

[sufiannaeem]

Just my 2 cents, but what if we use ImportRange, bring the same data to a different sheet, but also wrap it up in Filter or Unique (formula), so not double entries are shown?

[roman-orekhov]

I think you all can try using options of importJSON function.

@zenminimalist

1. =importJSON("https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=netSharePurchaseActivity", "/quoteSummary/result")
2. =importJSON("https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=netSharePurchaseActivity", "/", "noInherit")

@anaxoras

But in the google spreadsheets yo can see in raws 16 and 17 that the date is duplicated.

For each room id the last entry is duplicated. You can try this to avoid it: =(ImportJSON("https://app.thebookingbutton.com/api/v1/properties/hpdidirect/rates.json?&start_date=2018-11-12","/room_types","noInherit"))