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

xtk:session:Write to extened table.

  • August 27, 2018
  • 3 replies
  • 3366 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

A
Adobe Employee
anshshar_cfsAdobe Employee
Adobe 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

davidl14970702
davidl14970702Author
Level 4
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">

davidl14970702
davidl14970702AuthorAccepted solution
Level 4
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

Terms & ConditionsAccessibility statement

Loading footer...