ContributionsMost RecentMost LikesSolutionsRe: Using Property Transfer in Ready API, How Can I Transfer a Numeric Value into JSON object? Great! This is actually working. I just think it is a bit strange that when moving properties using Property Transfer or even entering values manually via Grid view it doesn't take the type of the attribute under consideration. Many thanks for your help, Rich! Cheers! Re: Using Property Transfer in Ready API, How Can I Transfer a Numeric Value into JSON object? Hi, It is type 'Excel' where I use a spreadsheet that contains my test data. Cheers, Re: Using Property Transfer in Ready API, How Can I Transfer a Numeric Value into JSON object? I'm not quite sure I got what you meant, but if you're referring to Q3, yes I get the JSON path expression hard coded when assigning values to be transferred from properties in the data source to the attribute in the JSON object in the request. Cheers! Re: Using Property Transfer in Ready API, How Can I Transfer a Numeric Value into JSON object? Hello again! First I want to thank for the effort you're putting to help me with this. I've been asking much lately about an easy way to cast a numeric value in a JSON attribute in ReadyAPI and I've not gotten the clear answer how to do that. Here comes the answers to your questions: A1. I'm using "Data Source Excel.xlsx". A2. In the same Data Source step one needs to create all the properties that correspond how the data looks in the columns in the excel sheet to be loaded and stored into when the Data Source step is being executed. A3.Yes, after all data has been fetched from the file.xlsx and stored in properties I use Property Transfer to distribute my data into JSON attributes for my REST request. I've tried both using Property Transfer way and assigning the data source direct for each attribute to be fetched from Data Source directly and in both ways my JSON request will automatically be populated correctly but all attributes are treated as text/string regardless if some of the attributes are numeric by definition or not. The attached picture I had in my previous comment shows the syntax that is being auto-generated when creating property transfer, neither that way or the auto-sourcing of data as you showed as "${DataSource#attribute1" has an effect on how the attribute will look like in my JSON object. All attributes are handled as string/txt fields as I mentioned. I think there should be a way to choose or adjust to these auto-generated syntax when assigning actions to attributes that are being transferred that allow the user to choose if this will be casting numeric or sting type of attribute. Many thanks again for your help so far 🙂 Regards, MFzOS Re: Using Property Transfer in Ready API, How Can I Transfer a Numeric Value into JSON object? Hello Rich and thanks for your response! The thing is that I am not using groovy script when transferring data. First I read data from excel file where I store the values in properties, then I use Property Transfer step to transfer these properties to fields in a JSON array. All values are transferred as string where some of the fields in the JSON are numeric. In the example below you can see the transfer step I use to transfer the value of the property "QUANTITY" to qty in JSON where the array will look : { "data" : { "info" : { "qty" : "1750" } } } Which is wrong because qty is numeric field and not string. Using Property Transfer in Ready API, How Can I Transfer a Numeric Value into JSON object? Hi, When fetching data source from EXCEL file, I need to transfer some of the values to JSON objects. All values are being parsed in as string format. How can I parse in values as integer instead when using property transfer step? Solved