Update Record Configuration
Totally frustrated with clarification in Help Document. I give up. The "Update Record Configuration" screen shows "Record ID" and gives no examples of any kind of what are you referring to as Record ID. I have a sequence number field i think is record id.
Here is my dilema. I imported 12,000 rows of records from SharePoint into Data Entity using the DB Insert Record instead of DE Insert Records which is too long to discuss reasons why. So i successfully imported all 12,000 rows over 3 days into Data Entity except the large comment/notes fields that would error out because of special characters embedded into the notes field.
Now when i attempt to use the DB Update Stencil I get same error as DB Insert Stencil but I know the AgilePoint Update Record Stencil should work because in the past when i've used the AgilePoint Insert record on these special characters I never have any problems.
Here is the problem. My Source is the SharePoint CAML Query to retrieve every record from SP and only update the notes fields for every records in SP and copy via subform that information into AgilePoint via the DE Update Record Stencil. I've tried everything but there is NOOOOO clarification in documentation what is RECORD ID: There is no GUID in SP to match my DE records. So i created a Query with AgilePoint DE to retrieve the matching record number in SP with records in DE table. Did my mapping and everything then i started thinking... How and where do i store the GUID record number from DE record into a Response Variable since there is no GUID datatype, so that isn't going to work.
So my question is 2 fold. Is RecordID the GUID or something else.. A simple screen shot example in your documentation would go a LONG way in showing us how to use the RECORD ID. If it is using the GUID how do i store the GUID in a variable since i don't see a GUID datatype.
Why can't your DE update record Stencil be like your SQL Update record stencil where i define the field I'm querying on to update the record.
-
Derek,
That happens sometime with article over internet. Let me see if can I be helpful.
As any Entity systems out there, Data Entity also has an Internal column ID which is the main value of all business logics which gets applied as part of the product.
When you are creating a new Entity you would have noticed the 'Record Internal Name' details which is the Primary key column details to be chose by the person designing the entity. At background ID column will be added and maintained by Data Entity which is referred as Record ID. The ID column's value got termed as Record ID.
In future version of the product, Record ID is not mandatory in Update Entity Activity as you see today, You can also use the primary key column which you choose during Entity Creation which would be lot more helpful in many cases.
In the documentation, https://documentation.agilepoint.com/00/appbuilder/cloudenvShapeUpdateDataEntity.html#UpdateDataEntity
The sentence 'Specifies an ID of a record to change in an AgilePoint NX entity.' is actually referring to the ID column in technical way though it sounds like regular business user sentence.
Regards,
Harish
Please sign in to leave a comment.
Comments
1 comment