JSON Data Source Dynamic Inputs and Record Filters


(Lewis) #1

Hi,

Does anyone have any experience of working with email addresses in the JSON that is returned from a JSON Data Source in Squiz v6?

I’ve got a JSON Data Source which pulls in data from a database as expected. I’ve linked the Data Source to an Asset Listing to rattle off the entries and that’s all fine.

When I get to the bit where I want to filter the records something odd happens - one of the fields in the JSON data is email_address which contains [drum roll] … and email address, but when I use that field in the Dynamic Inputs and Records Filters screen of the Data Source, I get the No Results bodycopy response in the Asset Listing.

As an aside, I have four other fields I’m referencing in the Dynamic Inputs and Records Filters screen, which all work perfectly - first_name, last_name, mobile_number, role etc. For some reason, email_address just returns no results :thinking:

I’ve checked the spelling throughout and can’t see any discrepencies. I’ve deleted the row in the Dynamic Inputs screen and recreated it, but it still doesn’t return anything when I use the email address input. I’ve checked the HTML form in the Asset Listing too, to make sure it’s the right POST parameter and that’s all fine.

Any ideas anyone?


JSON Data Source in Squiz v6?
(Lewis) #2

Just a quick update on this one - I’ve removed that ‘@’ symbol from an email address in the database, and a search for that email address now returns a result.