Expand my Community achievements bar.

SOLVED

Failure in SAINT import for report suite through API

Avatar

Level 2

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'

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

View solution in original post

6 Replies

Avatar

Correct answer by
Community Advisor

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.

Avatar

Level 2

"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')"

]

}

]

}

Avatar

Community Advisor

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?

Avatar

Level 2

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')

Avatar

Community Advisor

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')"

],

Avatar

Level 2

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