xtk:session:Write to extened table. | Community
Skip to main content
davidl14970702
davidl14970702
New Participant
August 27, 2018
Solved

xtk:session:Write to extened table.

  • August 27, 2018
  • 3 replies
  • 3362 views

Im not sure why this is not writing to the targeted table.

If I update xtkschema for the recipient table it works fine.

Any help would be great.

var table = <recipient
               xtkschema="lw:gospelCurriculumTmpTbl"
                _operation="insert"
               _key="@recipientId"
               recipientId="11111111"
               email="loyd.write@apitest.com"
               />;           
xtk.session.Write(table);
logInfo("---fin---")
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by davidl14970702

I found the problem.

my table is not an extension of the recipient table. I changed the XML tag to reflect the name of my table and my data showed up.

This resource was helpful in understanding what was happening.

Introduction

3 replies

davidl14970702
davidl14970702AuthorAccepted solution
New Participant
August 29, 2018

I found the problem.

my table is not an extension of the recipient table. I changed the XML tag to reflect the name of my table and my data showed up.

This resource was helpful in understanding what was happening.

Introduction

davidl14970702
davidl14970702Author
New Participant
August 28, 2018

I am running this in a workflow currently.

When it run's I don't get any errors back. But I'm not seeing data on the table as I would expect.

Initially, I thought xtkschema="lw:gospelCurriculumTmpTbl" was an extension of the recipient table but after checking I think it is it's own stand-alone table.

<srcSchema _cs="Gospel Curriculum Temp table (lw)" created="2017-10-25 11:52:24.480Z"

           createdBy-id="0" desc="Gospel Curriculum Temp table" entitySchema="xtk:srcSchema"

           img="xtk:schema.png" label="Gospel Curriculum Temp table" labelSingular="Gospel Curriculum Temp table"

           lastModified="2017-10-25 11:52:24.479Z" mappingType="sql" md5="657196B364BDDC620B5B21E5289D89B6"

           modifiedBy-id="0" name="gospelCurriculumTmpTbl" namespace="lw" xtkschema="xtk:srcSchema">

A
anshshar_cfs
Employee
August 28, 2018

Hi David

Can you share the error that you are getting using above sample?

If you are running this in a workflow (good idea for testing) you can activate the workflow property to log SQL queries in the journal to see where exactly it is failing.

Additionally, I see schema selected is xtkschema="lw:gospelCurriculumTmpTbl" . Can you confirm by any chance if this one is an extension of any other schema ?

Regards

Anshul

Terms & ConditionsAccessibility statement

Loading footer...