File Upload Utility

CoLab Community Tools
,
108

Hey Community, I was trying to use FUU for my script and been testing it. This is my CLI command -

java -jar “C:\Users\user\Downloads\Java\sailpoint-file-upload-utility-4.1.0.jar”
–url “``https://org-dev.api.identitynow.com``”
–clientId “5…8c”
–clientSecret “e4b…070”
–file “C:\Users\user\Downloads\FUU\2c9…722_Accounts.csv”
–objectType account
–simulate
–verbose

This was the response.

SailPoint File Upload Utility

Version:            4.1.0
Date:               2024-09-10 16:15 CST
Docs:               


URL:                https://org-dev.api.identitynow.com
Client ID:          5…398c
Files:              C:\Users\user\Downloads\FUU
ObjectType:         account
Optimization:       true
Recursive:          true
Extensions:         csv
Simulation:         true
Verbose:            true
Timeout:            10000

Checking credentials…
Analyzing directory: C:\Users\user\Downloads\FUU
Analyzing account file: 7d6…70_Accounts.csv
File [7d…70_Accounts.csv]: detected with source ID reference [7d…370].
File [7d…370_Accounts.csv]: Does not contain a valid source ID. Skipping…
Complete.

Elapsed time:       1 seconds
Files processed:    1

Success:            0

Error:              0

Skipped:            1
C:\Users\pettasi\Downloads\FUU\7d6…70_Accounts.csv

I made sure thatsource_id’s are correct and the schema matches. I even gave scope all to the PAT, still not sure why it’s saying this. Any help would be appreaciated.

PS: Masked ID’s for sensitivity

109

Hi Sita,

  You look to be using an Underscore (_) in the file name - could you try using aa hyphen (-)
111

Hey Darrel, Just tried with an hyphen, still the same.

Checking credentials…
Analyzing account file: C:\Users\pettasi\Downloads\FUU\fa336839e9e74470b3181f8b262db1cf-Accounts.csv
Analyzing account file: fa336839e9e74470b3181f8b262db1cf-Accounts.csv
File [fa336839e9e74470b3181f8b262db1cf-Accounts.csv]: detected with source ID reference [fa336839e9e74470b3181f8b262db1cf].
File [fa336839e9e74470b3181f8b262db1cf-Accounts.csv]: Does not contain a valid source ID. Skipping…
Complete.

112

Hey Darrel, Seems like the issue is when i use -Simulate, the actual upload is working as expected. Kindly look into this.

113

Our File Upload Utility has been working seamlessly and this error message is not helping with troubleshooting. The source file is populated, but the file it writes to is coming in blank. Can someone help point me in the right direction to troubleshoot this further???

Error: HTTP Code[400] Message[Bad Request] Body[{“detailCode”:“400.1 Bad request content”,“trackingId”:“cc…….d”,“messages”:[{“locale”:“en-US”,“localeOrigin”:“DEFAULT”,“text”:“The request was syntactically correct but its content is semantically invalid.”},{“locale”:“und”,“localeOrigin”:“REQUEST”,“text”:“The request was syntactically correct but its content is semantically invalid.”}],“causes”:}]

114

It seems , bad characters in the source files. Check the file content in notepad ++

Try uploading the exact same source file directly through the ISC UI on the source configuration page.

If the UI upload fails with the same error, the problem is definitively in the file’s content/format or the Source Schema configuration in ISC.

Try reducing the file content to just one row of data with only the absolutely required columns and test the upload again to eliminate the possibility of bad data in a specific record.