import datatype for a REST web service

Posted on

Hi,
We are importing a lot of (Rest) web services. In the web service, you can see the datatype’s for all the columns. The result for the procedure are all string (4000), and the table we make of the procedure it’s string (10). Can we get the actual datatypes without changing everything manually?
Is there an option in the wizard we don’t know?
Example web service:

<d:ID m:type="Edm.Int64">8725724278038038</d:ID>
<d:createdDate m:type="Edm.DateTimeOffset">2016-01-15T09:07:19.502Z</d:createdDate>
<d:WorkitemID m:type="Edm.String">505492684</d:WorkitemID>

Greeting Rob

rl

Responses