Does anyone have a SQLRPGLE program which is accessing FedEx or UPS using QSYS2.HTTP_ that they would be willing to share with me or by posting? I need to retrieve an authorization token from FedEx and UPS and I'm not sure if I should be using the QSYS2.HTTP_GET or the QSYS2.HTTP_POST. I've been trying and failing with UPS using both GET and POST. I will also need to do the same with FedEx in the future. Any help would be appreciated. Thanks.

I don't have a ready made solution for you, but maybe some tips.

First - it will not be easy. IBM i is an EBCDIC system, and the rest of the world is "speaking" UTF-8. RPGLE is awesome with UTF-8, but using embedded SQL with UTF-8 back and forth between is not for the faint of heart. Be ready to have some frustrating moments.

Start with a tool like Postman to explore the APIs of FedEx and UPS - especially the methods GET or POST - if you have your requests ready in Postman, it shouldn't be so hard, to recreate those requests with SQL.

The next step is, to try those requests with embedded SQL in RPGLE.

If your frustration is getting to hard, contact me - I can try to help.

Regards,
Daniel

Does anyone have a SQLRPGLE program which is accessing FedEx or UPS using QSYS2.HTTP_ that they would be willing to share with me or by posting? I need to retrieve an authorization token from FedEx and UPS and I'm not sure if I should be using the QSYS2.HTTP_GET or the QSYS2.HTTP_POST. I've been trying and failing with UPS using both GET and POST. I will also need to do the same with FedEx in the future. Any help would be appreciated. Thanks.

Hi Daniel,

Thank you for responding. You were correct about the frustration. But I finally got the QSYS2.HTTP_POST to work in a SQLRPGLE. 

I don't have a ready made solution for you, but maybe some tips.

First - it will not be easy. IBM i is an EBCDIC system, and the rest of the world is "speaking" UTF-8. RPGLE is awesome with UTF-8, but using embedded SQL with UTF-8 back and forth between is not for the faint of heart. Be ready to have some frustrating moments.

Start with a tool like Postman to explore the APIs of FedEx and UPS - especially the methods GET or POST - if you have your requests ready in Postman, it shouldn't be so hard, to recreate those requests with SQL.

The next step is, to try those requests with embedded SQL in RPGLE.

If your frustration is getting to hard, contact me - I can try to help.

Regards,
Daniel

Does anyone have a SQLRPGLE program which is accessing FedEx or UPS using QSYS2.HTTP_ that they would be willing to share with me or by posting? I need to retrieve an authorization token from FedEx and UPS and I'm not sure if I should be using the QSYS2.HTTP_GET or the QSYS2.HTTP_POST. I've been trying and failing with UPS using both GET and POST. I will also need to do the same with FedEx in the future. Any help would be appreciated. Thanks.

Hi Daniel,

Thank you for responding. You were correct about the frustration. But I finally got the QSYS2.HTTP_POST to work in a SQLRPGLE. 

I don't have a ready made solution for you, but maybe some tips.

First - it will not be easy. IBM i is an EBCDIC system, and the rest of the world is "speaking" UTF-8. RPGLE is awesome with UTF-8, but using embedded SQL with UTF-8 back and forth between is not for the faint of heart. Be ready to have some frustrating moments.

Start with a tool like Postman to explore the APIs of FedEx and UPS - especially the methods GET or POST - if you have your requests ready in Postman, it shouldn't be so hard, to recreate those requests with SQL.

The next step is, to try those requests with embedded SQL in RPGLE.

If your frustration is getting to hard, contact me - I can try to help.

Regards,
Daniel

Does anyone have a SQLRPGLE program which is accessing FedEx or UPS using QSYS2.HTTP_ that they would be willing to share with me or by posting? I need to retrieve an authorization token from FedEx and UPS and I'm not sure if I should be using the QSYS2.HTTP_GET or the QSYS2.HTTP_POST. I've been trying and failing with UPS using both GET and POST. I will also need to do the same with FedEx in the future. Any help would be appreciated. Thanks.

Hi Daniel,

Thank you for responding. You were correct about the frustration. But I finally got the QSYS2.HTTP_POST to work in a SQLRPGLE. 

I don't have a ready made solution for you, but maybe some tips.

First - it will not be easy. IBM i is an EBCDIC system, and the rest of the world is "speaking" UTF-8. RPGLE is awesome with UTF-8, but using embedded SQL with UTF-8 back and forth between is not for the faint of heart. Be ready to have some frustrating moments.

Start with a tool like Postman to explore the APIs of FedEx and UPS - especially the methods GET or POST - if you have your requests ready in Postman, it shouldn't be so hard, to recreate those requests with SQL.

The next step is, to try those requests with embedded SQL in RPGLE.

If your frustration is getting to hard, contact me - I can try to help.

Regards,
Daniel

Does anyone have a SQLRPGLE program which is accessing FedEx or UPS using QSYS2.HTTP_ that they would be willing to share with me or by posting? I need to retrieve an authorization token from FedEx and UPS and I'm not sure if I should be using the QSYS2.HTTP_GET or the QSYS2.HTTP_POST. I've been trying and failing with UPS using both GET and POST. I will also need to do the same with FedEx in the future. Any help would be appreciated. Thanks.

Hi Daniel,

I reached out to you and can send my source to you. The source retrieves a UPS authorization token. Let me know. Thanks, Doug.

Hi Daniel,

Thank you for responding. You were correct about the frustration. But I finally got the QSYS2.HTTP_POST to work in a SQLRPGLE. 

I don't have a ready made solution for you, but maybe some tips.

First - it will not be easy. IBM i is an EBCDIC system, and the rest of the world is "speaking" UTF-8. RPGLE is awesome with UTF-8, but using embedded SQL with UTF-8 back and forth between is not for the faint of heart. Be ready to have some frustrating moments.

Start with a tool like Postman to explore the APIs of FedEx and UPS - especially the methods GET or POST - if you have your requests ready in Postman, it shouldn't be so hard, to recreate those requests with SQL.

The next step is, to try those requests with embedded SQL in RPGLE.

If your frustration is getting to hard, contact me - I can try to help.

Regards,
Daniel

Does anyone have a SQLRPGLE program which is accessing FedEx or UPS using QSYS2.HTTP_ that they would be willing to share with me or by posting? I need to retrieve an authorization token from FedEx and UPS and I'm not sure if I should be using the QSYS2.HTTP_GET or the QSYS2.HTTP_POST. I've been trying and failing with UPS using both GET and POST. I will also need to do the same with FedEx in the future. Any help would be appreciated. Thanks.

Does anyone have a SQLRPGLE program which is accessing FedEx or UPS using QSYS2.HTTP_ that they would be willing to share with me or by posting? I need to retrieve an authorization token from FedEx and UPS and I'm not sure if I should be using the QSYS2.HTTP_GET or the QSYS2.HTTP_POST. I've been trying and failing with UPS using both GET and POST. I will also need to do the same with FedEx in the future. Any help would be appreciated. Thanks.

It is always handy to read the documentation ;-)

API Authorization Documentation | FedEx Developer Portal

Here you can see the required parameters, method (POST) and return values.

Does anyone have a SQLRPGLE program which is accessing FedEx or UPS using QSYS2.HTTP_ that they would be willing to share with me or by posting? I need to retrieve an authorization token from FedEx and UPS and I'm not sure if I should be using the QSYS2.HTTP_GET or the QSYS2.HTTP_POST. I've been trying and failing with UPS using both GET and POST. I will also need to do the same with FedEx in the future. Any help would be appreciated. Thanks.

Does anyone have a SQLRPGLE program which is accessing FedEx or UPS using QSYS2.HTTP_ that they would be willing to share with me or by posting? I need to retrieve an authorization token from FedEx and UPS and I'm not sure if I should be using the QSYS2.HTTP_GET or the QSYS2.HTTP_POST. I've been trying and failing with UPS using both GET and POST. I will also need to do the same with FedEx in the future. Any help would be appreciated. Thanks.

What have you been trying, and what exactly does "failing" look like?
Do you have a working example anywhere (i.e. Postman)?
I assume you are trying to use the client credentials grant ... https://developer.ups.com/tag/OAuth-Client-Credentials?loc=en_US

When I do this, I usually start with Postman. 
Once that's working I use Run SQL Scripts. 
Only then do I stick it into my RPG program.

Does anyone have a SQLRPGLE program which is accessing FedEx or UPS using QSYS2.HTTP_ that they would be willing to share with me or by posting? I need to retrieve an authorization token from FedEx and UPS and I'm not sure if I should be using the QSYS2.HTTP_GET or the QSYS2.HTTP_POST. I've been trying and failing with UPS using both GET and POST. I will also need to do the same with FedEx in the future. Any help would be appreciated. Thanks.

What have you been trying, and what exactly does "failing" look like?
Do you have a working example anywhere (i.e. Postman)?
I assume you are trying to use the client credentials grant ... https://developer.ups.com/tag/OAuth-Client-Credentials?loc=en_US

When I do this, I usually start with Postman. 
Once that's working I use Run SQL Scripts. 
Only then do I stick it into my RPG program.

Does anyone have a SQLRPGLE program which is accessing FedEx or UPS using QSYS2.HTTP_ that they would be willing to share with me or by posting? I need to retrieve an authorization token from FedEx and UPS and I'm not sure if I should be using the QSYS2.HTTP_GET or the QSYS2.HTTP_POST. I've been trying and failing with UPS using both GET and POST. I will also need to do the same with FedEx in the future. Any help would be appreciated. Thanks.