Convert the object output into type number

[Wei]

Hi, I have SQL connector function with a number output. Since it is a connector function, it outputs an object with the connector output as a property of the object. Do you have any recommendations as to the best way to convert the object output into type number so that it can be added to a table record (column of type number)?

[Brian_Haselton]

Yes, you will need to use a “Data Manipulation” “Store” action to accomplish this.

Here’s an example where we run a connector function and store the output in a variable. Then, you can use the second action to store each individual property in a number or text variable.