Skip to Content (Press Enter)
UserImage.jpg
Colin Crawford
0Views
4Comments
Update OS Entity from External data
Question
We have created a connection to an external table using Integration Studio (8.0.0.15).

What we'd like to do is to create a new Action, that will recurse through all of the rows in an external table and add or update records in an OS Entity using the CreateOrUpdatexxxxxx  method on the OS entity.

I have attached a Word document that has screen shots of what we have entered so far, including the error that is displayed.
  
The problem appears to be that the TYPE of the external data and the TYPE of the OS Entity aren't the same.

Any ideas?
OS_Screenshots.docx
0
0
11 Nov 2013
Copy Link
2016-04-21 18-13-58
Nuno Rolo
 
MVP
Hi Colin,

You need to have a variable Record of the type of the entity.
And in the cycle before the CreateOrUpdate, you have to assign each attribute.
0
0
11 Nov 2013
Copy Link
UserImage.jpg
Colin Crawford
I've done that but I get one more error (please see attached).  Do I need to do a conversion of some type?

 
error.png
0
0
11 Nov 2013
Copy Link
2016-04-21 18-13-58
Nuno Rolo
 
MVP
Yes, you need to use a function IntegerToEntityRefInteger or TextToEntityRefText if your Id is text.
0
0
11 Nov 2013
Copy Link
UserImage.jpg
Colin Crawford
Perfect!!  Thanks for your help
0
0
12 Nov 2013
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.