Failure in SAINT import for report suite through API

bhuwaneshp18

25-06-2018

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'

Accepted Solutions (1)

Accepted Solutions (1)

pabloc82923542

25-06-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.

Answers (5)

Answers (5)

bhuwaneshp18

25-06-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

pabloc82923542

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

],

bhuwaneshp18

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

bhuwaneshp18

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

]

}

]

}