This may be kind of an obscure problem but . . . I am trying to set up an integration between Kinetic and Hubspot using the workato hubspot connector. In general it works great. But I am trying to create a contact in hubspot and one of the fields I need to populate is the company association. I am searching for the record ID of the company in Hubspot and then sending that in my put request. But somehow workato is treating the returned record ID of the company as a decimal instead of a string and appending “.0” to it which then of course doesn’t match anything.
I’ve tried using to int and to string on my data pill but neither works - to string does not get rid of the .0, and to int just ends up null.
Has anyone ran into something similar or have any ideas what to do about this? I know Epicor support can put a ticket to workato for me but that process is like molasses.
