Failure in SAINT import for report suite through API

[bhuwaneshp18]

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'

[Pablo_Childe · Accepted solution]

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.

[bhuwaneshp18]

"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]

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?

[bhuwaneshp18]

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]

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

],

[bhuwaneshp18]

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