Need Help with CURL Extract

Victor Swindell

I'm trying to follow the documentation for the API to write a curl statement to download our awards

I have a working one that will download everything...but I want to filter out all the archived ones...


is there anyone on here that can help with this...

Elizabeth Perron

Moved to the Sky Developer Community in hopes of having more developer eyes on this question.


Elizabeth

Blackbaud Community Team

Bobby Earl

Hi Victor. 


I have some ideas that may help you.  Would you mind sharing the link to the documentation you're following along with, so we can make sure we're talking about the same thing?


Thanks,


Bobby

Victor Swindell

The documentation I’m using is from your own
site

https://cofc.academicworks.com/docs/fund_disbursements_current

 

Victor C.
Swindell

Programmer/Analyst
III

Division of
Information Technology

College of
Charleston

843.953.7522

Stay connected with IT!

 

“You
know the very powerful and the very stupid have one thing in
common.

They
don’t alter their views to fit the facts.

They
alter the facts to fit their views.

Which
can be uncomfortable… if you happen to be one of the facts that
needs altering.”

-The
Doctor

 

Kody Jackson

Howdy Victor,


You should be able to filter out the archived opportunities by setting the parameter for opportunity_archived equal to No.



 

Victor Swindell

As an Update...and clarification

I have a CURL command..that seems to work as desired if I put it in a DOS BAT file.

curl --verbose -g -o "N:\\csas_file1.txt" "https://myschool.academicworks.com/api/v1/disbursements.csv?c[]=initial_application_category_name__contains__Offered__contains__Accepted&c[]=opportunity_archived__eq__0&page=1&per_page=1000&fields=award_period_name,user_uid,portfolio_code,disbursement_amount&token=faketoken"



However, I I put the command in a BASH Script


curl --verbose -g -o "/mnt/itfiletrans/csas_file1.txt" "https://myschool.academicworks.com/api/v1/disbursements.csv?c[]=initial_application_category_name__contains__Offered__contains__Accepted&c[]=opportunity_archived__eq__0&page=1&per_page=1000&fields=award_period_name,user_uid,portfolio_code,disbursement_amount&token=faketoken"




I get


400 Bad Request


Can Anyone Help?

 

Josh Smith

Hi Victor,


The URL contains a number of special characters which need to be escaped; in Bash, symbols like & ? and , have a special meaning.


Try wrapping the URL in single quotes ( ' ) and not double quotes ( " ).

Victor Swindell

I tried this...

curl --verbose -g -o "/mnt/itfiletrans/csas_file1.txt" 'https://myschool.academicworks.com/api/v1/disbursements.csv?c[]=initial_application_category_name__contains__Offered__contains__Accepted&c[]=opportunity_archived__eq__0&page=1&per_page=1000&fields=award_period_name,user_uid,portfolio_code,disbursement_amount&token=faketoken


And I'm still getting 400  Bad request


is there another way to construct this...this is my first venture using Curl...and the only documentation for the API is the one Blackbaud gives.

Kody Jackson

In the example you posted, you're missing a single quotation mark (') at the end of your URL.


Maybe that's the issue?

Victor Swindell

Nah...just forgot to add it

Victor Swindell

So it would look like this (except I have my real school and Token)

curl --verbose -g -o "/mnt/itfiletrans/csas_file1.txt" 'https://myschool.academicworks.com/api/v1/disbursements.csv?c[]=initial_application_category_name__contains__Offered__contains__Accepted&c[]=opportunity_archived__eq__0&page=1&per_page=1000&fields=award_period_name,user_uid,portfolio_code,disbursement_amount&token=faketoken'


I can do this call with a DOS BATCH file and it works fine...but if I put it in a .SH file and call it..   I get a 400 error


has anyone used a script with UC4 to get distributions?

darcelle cowles

@Victor Swindell
Do you see anything wrong with my curl ? I am running on the command line and it will be a shell script if I ever get it to work.

curl --verbose -g -o award_period.csv ‘https://tjc.academicworks.com/api/v1/disbursements/award_period.csv&page=1&per_page=1000&fields=award_period_name&token=xxxxx’

I am only trying to get one field called award period name. I have not gotten to the point of filtering out field data.