How to add data type

Question

We have Json file as input source which some random data for that values we need to add datatypes.
Sample data:
{
“Id”: “1076”,
“jobTitle”: “Software engineer”,
“firstName”: “David”,
“lastName”: “villey”,
“fullName”: “Davidvilley”,
“email_N”: “Davidvilley@gmail.com”,
“telephoneNumber”: “+1-8474987109”
}
Please help me to add the datatypes for above data to validate.

darshthakkar · Answer

Hi @Pretty,
You can use “type converter” snap to add/modify data type, let me know how it goes.

ljupcho_machko1 · Answer

@Pretty , in the given sample data all the values are type String. You can use Type Inspector snap for this.

koryknick · Answer

@Pretty - I think we need a bit more description of what you’re trying to do here.  If you just want to convert $Id to a number, you can use the built-in expression language function parseInt($Id) in a Mapper snap.
As @ljupcho_machkovski pointed out, everything else is a String.  JSON only supports a small number of data types: String, Number, Object, Array, or Boolean.

koryknick · Answer

There is a Data Validator snap in the Flow snap pack, which is Public so you have access to it.  As I stated, JSON supports a limited set of data types and does not restrict length or precision, so the Data Validator is probably your best bet.

darshthakkar · Answer

koryknick:

you can use the built-in expression language function parseInt($Id) in a Mapper snap.

Agreed, you can use a mapper for conversion to integer, string (fieldname.toString())

Forum Discussion

How to add data type

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?