A DataRaptor must convert a string field to an integer before sending to an external service. Which action fixes this?

A DataRaptor must convert a string field to an integer before sending to an external service. Which action fixes this?

• A. In the DataRaptor Output tab, enter the default value as 0 on the field.
• B. In the DataRaptor Extract tab, set the Input Data Type field to Integer.
• C. In the DataRaptor Formula tab, define a formula using the function TOINTEGER and use the formula as output.
• D. In the DataRaptor Output tab, select the Output Data Type of that field to Integer.

Answer: (C)

Converting the value at transformation time with a formula is the reliable way to ensure the string becomes an integer before it’s sent out. In the DataRaptor Formula tab you can create a formula that uses the TOINTEGER function on the string field, then use that formula’s result as the output value. This explicit conversion guarantees the external service receives an integer, rather than a string. Other approaches don’t perform a proper runtime conversion. Setting a default value only fills in when the field is missing and doesn’t convert the incoming string. Changing the input data type in the Extract tab affects how data is read, not how it’s transformed for output. Changing the output data type alone doesn’t convert the actual value; it merely declares how the value should be treated on output without performing the conversion itself.

Converting the value at transformation time with a formula is the reliable way to ensure the string becomes an integer before it’s sent out. In the DataRaptor Formula tab you can create a formula that uses the TOINTEGER function on the string field, then use that formula’s result as the output value. This explicit conversion guarantees the external service receives an integer, rather than a string.

Other approaches don’t perform a proper runtime conversion. Setting a default value only fills in when the field is missing and doesn’t convert the incoming string. Changing the input data type in the Extract tab affects how data is read, not how it’s transformed for output. Changing the output data type alone doesn’t convert the actual value; it merely declares how the value should be treated on output without performing the conversion itself.