I am new to FME Server. Hope I can get some help from here.
I want to get a list of completed jobs with status and username from our FME Server. I can get jobs with status via a http call - /fmerest/v2/transformations/jobs/completed. But I didn't see the username info exposed through this rest endpoint. I know the postgresql fme_job_history table stores the username info. How can I retrieve it through a http call?
Thanks all for your help.
Best answer by stalknecht
View original
+18
You can get the information with the following http call where 150 is the job_id:
~/fmerest/v2/transformations/jobs/id/150/log?detail=high
You can get the information with the following http call where 150 is the job_id:
~/fmerest/v2/transformations/jobs/id/150/log?detail=high
Thank stalknecht for your response. So if I have over 1000 completed jobs, i have to make 1000 calls to the server and parse each response to get the username info? I saw the fme_job_history table has every info I need, is there a transformer i can use to make ONE database call in a workspace to get all i need? Thanks for your help.
+18
You can get the information with the following http call where 150 is the job_id:
~/fmerest/v2/transformations/jobs/id/150/log?detail=high
Sure, the sqlExecuter or sqlCreator could do that.
You can get the information with the following http call where 150 is the job_id:
~/fmerest/v2/transformations/jobs/id/150/log?detail=high
Thank you so much! sqlCreator works for my purpose.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
