Can't Import JSON file

[marca_at_cue]

Can somebody help me figure out what I'm doing wrong here. Simply trying to open a JSON file that was pushed out from BigQuery.  I'm trying to build a process, but can get started with out this json file imported as the first step.

NOTE: I had to store the json file as a zip b/c json wasn't a support file type for attachments.

I'm assuming it has something to do with the structure of the json file.  That will be problematic b/c I'm wanting to automate some steps.

[gawa · Accepted solution]

hi @marca_at_cue 

In configuration window of Input File tool, please specify Code Page as UTF-8 while you specified UTF-16, then you can read json correctly.

For your ready reference, please find the attached workflow.

[marca_at_cue]

Excellent feedback.  Thank you for the quick turnaround on that solution!!!