Also was having an issue with google drive json file being read correctly if you have any experience with that I seem to be missing something? I am trying to transfer my data from google maps so that I can post it to Instagram and I started doing the process manually put got approximately 1% of the through before I realized it would take forever and I was hoping I could automate at least some of the parts to make it somewhat faster. Any/all help is much appreciated.
Hey @Umami.Haven! If youâre reporting an issue with a flow or an error in a run, please include the run link and make sure itâs shareable so we can take a look.
Find your run link on the history page. Format: https://www.gumloop.com/pipeline?run_id={{your_run_id}}&workbook_id={{workbook_id}}
Make it shareable by clicking âShareâ â âAnyone with the link can viewâ in the top-left corner of the flow screen.
Provide details about the issueâmore context helps us troubleshoot faster.
Hey @Umami.Haven â To extract âdateâ, âfive_star_published_ratingâ (which is actually âfive_star_rating_publishedâ in your data), and âgoogle_maps_urlâ from your JSON, youâd have to use dot notation to access these properties within the nested structure.
Examples:
For the âdateâ field: features.0.properties.date
For the âgoogle_maps_urlâ field: features.0.properties.google_maps_url
If you want to extract all the items from each nested array, it might be easier to create a custom node. You can check out the documentation here and thereâs also a video tutorial as well as a Custom Node Workshop.
Thanks Wasay- I will have to check this out tomorrow, heading to bed now! I am almost there, but now the data exported is not useable (seems like it is being exported in a json code still?)
