Looking at the freshdesk.conversation table I'm trying to figure out the best way to distinguish between phone calls, emails and text messages. There's a field in the table called 'source' that has numerical values but I'm not too sure what those values map to, or if thats the right field i should even be looking at.
Does anyone know how can i tell whether a row in the conversations table is either an email, phone call or text?
I believe you are referring to the conversations fetched via the API calls. Then the numerical values denote a particular source. I'm attaching a screenshot of the same for your perusal.
You can read more about the API's in our API document linked here.
If you have any further queries, please feel free to write to firstname.lastname@example.org and one of our support ninjas will sort out your issues.