Data Source/Import Set not automatically running transform

[jshatney]

Using the following article, I have created an inbound e-mail action that is automatically creating a data source using the attached CSV file from an inbound email.

UPDATED - Use an email with an attachment to create a Data Source, Load Data, and Run Transform

The creation of the Data Source is working beautifully.   When I manually run the transform map, it works great. The issue I'm seeing here is that when the inbound email comes in, the new data sources is generated, the data loads, but the transform does not complete.

Does anyone have any insight as to why a transform map would not run automatically on a new import? (there are no transform errors)
OR does anyone have any alternative methods for triggering a transform once a import has completed?

Any help would be appreciated.

[Jamie_douglas]

Hi,

I had this issue once before. What is happening is your first part of the code that creates the attachment is working fine, then the REST message part which is the part that actually triggers the transformation inst working. This is because you need to provide credentials for basic authentication. Even though this is in the instance you are triggering the transformation for the REST message essentially inserts an action via URL so that request needs to be authenticated to be allowed to process.

Make sure you tick basic auth on your rest message and provide username/password.

Im sure this will fix it if not can you screen shot your rest message so that we can see the URLs etc that you are using?

If this fixes your issue please mark this question as answered or helpful.

Thanks

Jamie

[jshatney]

Amazingly enough, I had already tested and verified that the basic auth was setup with a correct password and working.

I did, however, happen to notice when I went back into my GET function, that I had a typo in one of the parameters. Corrected my typo and everything is working as expected!

Thanks~!

[akillius]

Hey guys-

So I am running into this issue as well.   I have validated nothing is typed incorrectly and that basic auth is checked with admin and our admin pw but it is still not loading the data.   In the GET msg, it is returning http code 200 when I test so I know it is valid.  

Is there any logging you can point me to to see why it is failing?

Andy

[dabi]

For anyone finding this post now, here is an updated link to the latest information I could find on this.

At least it may be relevant to helping you figure it out.  

https://community.servicenow.com/community?id=community_blog&sys_id=908c26e1dbd0dbc01dcaf3231f9619c4