Forum Discussion

NoorAlfar's avatar
NoorAlfar
Helper I
2 years ago
Solved

JSON in dataflow and power query

Hi,   Im using this flow to get data from Freshdesk   where the filename is  concat('DailyUpdates',formatDateTime(utcNow(),'yyyy-MM-dd-HHmm'),'.json')   I want to open these f...
Dataflow
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    2 years ago

    Save these daily snapshots on a suitable storage system (OneDrive for example) and ingest them as is. 

lbendlin's avatar
lbendlin
Super User
2 years ago

Depends on your archival strategy.  Is the file easily re-fetchable from the API or do you need to preserve snapshots?

NoorAlfar's avatar
NoorAlfar
Helper I
2 years ago

I'm pulling data on daily basis only the updated records so I need to save the snapshot.

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Save these daily snapshots on a suitable storage system (OneDrive for example) and ingest them as is.