Any successful JSON connections?

rollthejewels

Hi there,

 

I'm attempting to use the basic JSON connector, and I run into what I believe is a column limit error.

 

I want to use the connector to filter down to specific properties, but I'm not sure what the syntax is for this field or even JSON in general.

 

Does anybody have any good starting points on how to learn or where to start?

 

Thanks,

Adam

[Deleted User]

@rollthejewels

 

Thanks for your post! Have a look at these docs:

 

http://knowledge.domo.com?cid=connect

 

http://knowledge.domo.com?cid=json

 

Regards,

 

rollthejewels

Thanks Dani. 

 

I've reviewed the DOMO connector guide already and that doesn't really help, and I'm not technically savvy enough to figure out what I need from the API guide (it's a little too technical).

 

Specifically what I'm looking for is just the syntax for these fields:

Darius

rollthejewels,

 

It sounds like you need to add some entries to "Enter Fields to Exclude" for your use case, but all of the "Additional Options" you are referring to are optional, so you don't necessarily have to fill them all out. Here is a simple description of the fields that you are referring to:

• Header tag: If your file has a header, you can enter the tag that your header uses
• Data tag: If your data in  your JSON file has a tag you can enter it
• Enter Fields to Exclude: Enter a comma-delimited list of column names you want the connect to ignore (I don't believe you need the single quotes)

If you run into specific issues, please describe them here, otherwise, you may give our "JSON Advanced with custom parsing" connector, which is more interactive through the configuration process, making much of the setup easier for you.

 

Regards,

rollthejewels

Thanks Darius.  

 

In the image below, I highlighted the ultimate value I'm trying to get to, which is "score."  I highlighted the hierarchy within that as well, but I'm not sure how/which to reference otherwise to exclude (e.g. runWarnings, audits, etc. all at a higher level)

 

rollthejewels

BUMP

 

Anybody have any ideas for the above?

[Deleted User]

@Darius any additional thoughts here?

Thanks!