Failure in SAINT import for report suite through API | Community
Skip to main content
B
bhuwaneshp18
Level 2
June 25, 2018
Solved

Failure in SAINT import for report suite through API

  • June 25, 2018
  • 6 replies
  • 3122 views

every time when import the data in report suit through Analytics 1.4 APIs its showing the following error

Import Status
Error:First column is required to be the key

So can you please in this, where i make mistake if possible please send me some demo code with two columns like 'Key' and 'Category Field'

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 Pablo_Childe

Might help if you post your present code format that is causing the error.

Also make sure first line of API request is indeed the the SAINT 'key' variable.

6 replies

Pablo_Childe
Community Advisor
Pablo_ChildeCommunity AdvisorAccepted solution
Community Advisor
June 25, 2018

Might help if you post your present code format that is causing the error.

Also make sure first line of API request is indeed the the SAINT 'key' variable.

B
bhuwaneshp18Author
Level 2
June 25, 2018

"check_divisions":"0",

"description":"Import Video CSHK",

"element":"evar9",

"email_address":"xxxxxxxxxxxx,

"export_results":"0",

"header":[

"( 'Key','Video Category')"

],

"overwrite_conflicts":"1",

"rsid_list":[

"ags545cgdev"

]

}

For PopulatedImport

{

"job_id":"21564875",

"page":"1",

"rows":[

{

"row":[

"('adsadsad','jhjhgjhgj')"

]

}

]

}

Pablo_Childe
Community Advisor
Pablo_ChildeCommunity Advisor
Community Advisor
June 25, 2018

ok for clarity what are the elements you are trying to import?

Can you rank them and then also highlight which one is the Key variable?

B
bhuwaneshp18Author
Level 2
June 25, 2018

header":[

"( 'Key','Video Category')"

],

These are the element, key and video category

And I import these value from populated import method and values are

('adsadsad','jhjhgjhgj')

Pablo_Childe
Community Advisor
Pablo_ChildeCommunity Advisor
Community Advisor
June 25, 2018

ok so to verify you have an evar9 that is called "Video Category"?

Would I be right in saying you could have an evar designated to "Video name", you then want to use SAINT to create a Category group for it?

Also I see a little space in your code that could be tripping up things..

YOUR copy

header":[

"( 'Key','Video Category')"

],

DELETED extra space in front of key

header":[

"('Key','Video Category')"

],

B
bhuwaneshp18Author
Level 2
June 26, 2018

I have tried with this  when i create import job it show me a job id, with that job id if i populated import it show me result "true" and after commitimport it also show me result "true",

But every time a got error email from adobe '

Failure in SAINT import for report suite through API

Please if possible can you provide me a sample code for all three stages with a sample element

Terms & ConditionsAccessibility statement

Loading footer...