How to load data from workfront project management application to sql server

Question

How to load data from workfront project management application to sql server

Nishi Intwala 1

How can I retrieve Data from Workfront a project management application to SQL Server ? Any help is appreciated. I found this thread, but it has been archived
https://social.msdn.microsoft.com/Forums/en-US/19d8baef-5d94-4a87-8383-3d4b3b6c7242/loading-data-from-workfront-project-management-application-into-sql-server

1 answer

Your answer

Answer 1

Ronen Ariely 15,206

Hi,

(1) I recommend to ask the question in the Workfront forum since it is much more relevant there:

https://one.workfront.com/s/

(2) The link you provided include a solution - please elaborate why/if this not fit your needs

Option 1: export the data to csv -> import to the SQL Server using bcp

Option 2: use Workfront API and connect Workfront using externalk application which can also connect the SQL Server (C#, vb.Net or any other language/tech).

https://developer.workfront.com/

Nishi Intwala 1 Reputation point

2022-01-24T18:51:12.547+00:00
Thank you for your answer @Ronen Ariely ,

I will ask the question on the Workfront forum.

I cannot do that using EXCEL since it is a very tedious process of adding all columns and then exporting it, and i will need to do that every time data is refreshed

I guess, i am asking this because I am new to API and I was wondering if python is the way to use the Workfront API correctly, because i want to retrieve ALL the data onto SQL
Ronen Ariely 15,206 Reputation points

2022-01-27T11:39:52.697+00:00

I guess, i am asking this because I am new to API and I was wondering if python is the way to use the Workfront API correctly,

I think that you can close this thread and continue the discussion in the right forum where you will have experts in the specific API :-)

Share via

How to load data from workfront project management application to sql server

1 answer

Your answer