bubulindo / RockwellLifeCycle

This is a script to pull the lifecycle status data off of Rockwell Automation's website.
2 stars 0 forks source link

client keys #1

Open bubulindo opened 1 year ago

bubulindo commented 1 year ago
imagem
ryoshiaki commented 3 months ago

it's not working anymore any solution?

bubulindo commented 3 months ago

Funny you mention this, I need to look into it for work, I’ll check it tomorrow.

On Mon, 12 Aug 2024 at 20:38, ryoshiaki @.***> wrote:

it's not working anymore any solution?

— Reply to this email directly, view it on GitHub https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2284771146, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAKE6JYA76A3S7EYJCDIAPLZREFJTAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBUG43TCMJUGY . You are receiving this because you authored the thread.Message ID: @.***>

bubulindo commented 3 months ago

Hello,

I had a look now and noticed some other problem, but the main reason it wasn't working was Rockwell changing the site holding the data.

To fix it, replace line 12 of the script from this:

url = "https://es-be-ux-search.cloudhub.io/api/ux/v2/search?queryText=" + part_number + "&role=rockwell-search&spellingCorrect=true&spellcheckPremium=10&segments=Productsv4&startIndex=0&numResults=20&facets=&languages=en&locales=en-GB,en_GLOBAL&sort=bma&collections=Literature,Web,Sample_Code&site=RA"

To this:

url = " https://api.rockwellautomation.com/ra-papi-gsm-search-vpcprod/api/v2/ux/search?queryText="

On Mon, 12 Aug 2024 at 22:15, Carlos Cardoso @.***> wrote:

Funny you mention this, I need to look into it for work, I’ll check it tomorrow.

On Mon, 12 Aug 2024 at 20:38, ryoshiaki @.***> wrote:

it's not working anymore any solution?

— Reply to this email directly, view it on GitHub https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2284771146, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAKE6JYA76A3S7EYJCDIAPLZREFJTAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBUG43TCMJUGY . You are receiving this because you authored the thread.Message ID: @.***>

ryoshiaki commented 3 months ago

Hi,

Thanks for the reply.

Could you check the secret key? And the other key? Because they are returning error 500 query failure.

Em ter., 13 de ago. de 2024 10:07, bubulindo @.***> escreveu:

Hello,

I had a look now and noticed some other problem, but the main reason it wasn't working was Rockwell changing the site holding the data.

To fix it, replace line 12 of the script from this:

url = "https://es-be-ux-search.cloudhub.io/api/ux/v2/search?queryText=" + part_number + "&role=rockwell-search&spellingCorrect=true&spellcheckPremium=10&segments=Productsv4&startIndex=0&numResults=20&facets=&languages=en&locales=en-GB,en_GLOBAL&sort=bma&collections=Literature,Web,Sample_Code&site=RA"

To this:

url = "

https://api.rockwellautomation.com/ra-papi-gsm-search-vpcprod/api/v2/ux/search?queryText="

  • part_number + "&role=rockwell-search&spellingCorrect=true&spellcheckPremium=10&segments=Productsv4&startIndex=0&numResults=10&facets=&languages=en&locales=en-GB,en_GLOBAL&sort=bma&collections=Literature,Web,Sample_Code&site=RA"

On Mon, 12 Aug 2024 at 22:15, Carlos Cardoso @.***> wrote:

Funny you mention this, I need to look into it for work, I’ll check it tomorrow.

On Mon, 12 Aug 2024 at 20:38, ryoshiaki @.***> wrote:

it's not working anymore any solution?

— Reply to this email directly, view it on GitHub < https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2284771146>,

or unsubscribe < https://github.com/notifications/unsubscribe-auth/AAKE6JYA76A3S7EYJCDIAPLZREFJTAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBUG43TCMJUGY>

. You are receiving this because you authored the thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2286216833, or unsubscribe https://github.com/notifications/unsubscribe-auth/BKGDTEFAWT73A36Z2BQYW3DZRIAKNAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBWGIYTMOBTGM . You are receiving this because you commented.Message ID: @.***>

bubulindo commented 3 months ago

I've checked this in my laptop and it works fine, so I'm now wondering if this is something generated for this laptop (which would make perfect sense).

So, you'll have to do some of the legwork on your end. The line 12 I mentioned needs replacing, then you need to go to:

https://www.rockwellautomation.com/en-gb/support/product/product-compatibility-migration/product-lifecycle-status.html

I use Firefox and open the developer tools which is the view you see in the attached picture.

Type in a part number that exists, like 1756-L81E and press search.

Go through the network traffic and you should see a request/response just like the highlighted one. Click in headers and scroll down and you should see the client_id, client_secret, etc... copy those values and type them in the correct place in your local copy of the script.

Captura de ecrã 2024-08-13, às 21 30 57

I remember now running this script on both my Mac at home and Windows PC at work and it worked fine as it was. Maybe it's an issue with the region you're in and where Rockwell directs your request. If this is the case, you should see the website that the request is made to when you click to search.

Hopefully this solves the issue.

On Tue, 13 Aug 2024 at 14:37, ryoshiaki @.***> wrote:

Hi,

Thanks for the reply.

Could you check the secret key? And the other key? Because they are returning error 500 query failure.

Em ter., 13 de ago. de 2024 10:07, bubulindo @.***> escreveu:

Hello,

I had a look now and noticed some other problem, but the main reason it wasn't working was Rockwell changing the site holding the data.

To fix it, replace line 12 of the script from this:

url = "https://es-be-ux-search.cloudhub.io/api/ux/v2/search?queryText=" + part_number +

"&role=rockwell-search&spellingCorrect=true&spellcheckPremium=10&segments=Productsv4&startIndex=0&numResults=20&facets=&languages=en&locales=en-GB,en_GLOBAL&sort=bma&collections=Literature,Web,Sample_Code&site=RA"

To this:

url = "

https://api.rockwellautomation.com/ra-papi-gsm-search-vpcprod/api/v2/ux/search?queryText="

  • part_number +

"&role=rockwell-search&spellingCorrect=true&spellcheckPremium=10&segments=Productsv4&startIndex=0&numResults=10&facets=&languages=en&locales=en-GB,en_GLOBAL&sort=bma&collections=Literature,Web,Sample_Code&site=RA"

On Mon, 12 Aug 2024 at 22:15, Carlos Cardoso @.***> wrote:

Funny you mention this, I need to look into it for work, I’ll check it tomorrow.

On Mon, 12 Aug 2024 at 20:38, ryoshiaki @.***> wrote:

it's not working anymore any solution?

— Reply to this email directly, view it on GitHub <

https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2284771146>,

or unsubscribe <

https://github.com/notifications/unsubscribe-auth/AAKE6JYA76A3S7EYJCDIAPLZREFJTAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBUG43TCMJUGY>

. You are receiving this because you authored the thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub < https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2286216833>,

or unsubscribe < https://github.com/notifications/unsubscribe-auth/BKGDTEFAWT73A36Z2BQYW3DZRIAKNAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBWGIYTMOBTGM>

. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2286275278, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAKE6J37WOLU3EIXHI6V3SLZRIDYBAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBWGI3TKMRXHA . You are receiving this because you authored the thread.Message ID: @.***>

ryoshiaki commented 3 months ago

Hi, thank you it works fine, now I will develop a interface for that something like the user can put the product code and then the app returns that information. Btw do you have something in your mind about siemens lifecycle? I am trying to develop something like search a standard link + product code and specifics field to consult, but i saw a api develop by siemens but we have to buy a apikey/client id to use the api.

Em ter., 13 de ago. de 2024 17:37, bubulindo @.***> escreveu:

I've checked this in my laptop and it works fine, so I'm now wondering if this is something generated for this laptop (which would make perfect sense).

So, you'll have to do some of the legwork on your end. The line 12 I mentioned needs replacing, then you need to go to:

https://www.rockwellautomation.com/en-gb/support/product/product-compatibility-migration/product-lifecycle-status.html

I use Firefox and open the developer tools which is the view you see in the attached picture.

Type in a part number that exists, like 1756-L81E and press search.

Go through the network traffic and you should see a request/response just like the highlighted one. Click in headers and scroll down and you should see the client_id, client_secret, etc... copy those values and type them in the correct place in your local copy of the script.

I remember now running this script on both my Mac at home and Windows PC at work and it worked fine as it was. Maybe it's an issue with the region you're in and where Rockwell directs your request. If this is the case, you should see the website that the request is made to when you click to search.

Hopefully this solves the issue.

On Tue, 13 Aug 2024 at 14:37, ryoshiaki @.***> wrote:

Hi,

Thanks for the reply.

Could you check the secret key? And the other key? Because they are returning error 500 query failure.

Em ter., 13 de ago. de 2024 10:07, bubulindo @.***> escreveu:

Hello,

I had a look now and noticed some other problem, but the main reason it wasn't working was Rockwell changing the site holding the data.

To fix it, replace line 12 of the script from this:

url = "https://es-be-ux-search.cloudhub.io/api/ux/v2/search?queryText="

+

part_number +

"&role=rockwell-search&spellingCorrect=true&spellcheckPremium=10&segments=Productsv4&startIndex=0&numResults=20&facets=&languages=en&locales=en-GB,en_GLOBAL&sort=bma&collections=Literature,Web,Sample_Code&site=RA"

To this:

url = "

https://api.rockwellautomation.com/ra-papi-gsm-search-vpcprod/api/v2/ux/search?queryText="

  • part_number +

"&role=rockwell-search&spellingCorrect=true&spellcheckPremium=10&segments=Productsv4&startIndex=0&numResults=10&facets=&languages=en&locales=en-GB,en_GLOBAL&sort=bma&collections=Literature,Web,Sample_Code&site=RA"

On Mon, 12 Aug 2024 at 22:15, Carlos Cardoso @.***> wrote:

Funny you mention this, I need to look into it for work, I’ll check it tomorrow.

On Mon, 12 Aug 2024 at 20:38, ryoshiaki @.***> wrote:

it's not working anymore any solution?

— Reply to this email directly, view it on GitHub <

https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2284771146>,

or unsubscribe <

https://github.com/notifications/unsubscribe-auth/AAKE6JYA76A3S7EYJCDIAPLZREFJTAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBUG43TCMJUGY>

. You are receiving this because you authored the thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub <

https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2286216833>,

or unsubscribe <

https://github.com/notifications/unsubscribe-auth/BKGDTEFAWT73A36Z2BQYW3DZRIAKNAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBWGIYTMOBTGM>

. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub < https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2286275278>,

or unsubscribe < https://github.com/notifications/unsubscribe-auth/AAKE6J37WOLU3EIXHI6V3SLZRIDYBAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBWGI3TKMRXHA>

. You are receiving this because you authored the thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2287095364, or unsubscribe https://github.com/notifications/unsubscribe-auth/BKGDTED3HXI75WDNMUP3A3DZRJVARAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBXGA4TKMZWGQ . You are receiving this because you commented.Message ID: @.***>

bubulindo commented 3 months ago

I thought about the user interface, but if I need one part it's less work to actually go to Rockwell's website and pick its status up. But I'm in charge of one site and have a list of parts installed and it's far easier for me to feed the parts in a file than type it.

I haven't looked at Siemens lifecycle for two reasons:

Sadly, Siemens has been learning the bad habits from Rockwell so I imagine that one would at least need an account with them to be able to use the API? Do you have a Siemens rep you can get in touch with?

As I mentioned, this isn't a project dedicated to the community, it's really to make my life simple and be able to justify investment in replacing obsolete automation devices from my plant. Also, because I've been bit before thinking the oldest gear was less supported which is not the case at all and this helps to get a clearer picture.

On Wed, 14 Aug 2024 at 00:48, ryoshiaki @.***> wrote:

Hi, thank you it works fine, now I will develop a interface for that something like the user can put the product code and then the app returns that information. Btw do you have something in your mind about siemens lifecycle? I am trying to develop something like search a standard link + product code and specifics field to consult, but i saw a api develop by siemens but we have to buy a apikey/client id to use the api.

Em ter., 13 de ago. de 2024 17:37, bubulindo @.***> escreveu:

I've checked this in my laptop and it works fine, so I'm now wondering if this is something generated for this laptop (which would make perfect sense).

So, you'll have to do some of the legwork on your end. The line 12 I mentioned needs replacing, then you need to go to:

https://www.rockwellautomation.com/en-gb/support/product/product-compatibility-migration/product-lifecycle-status.html

I use Firefox and open the developer tools which is the view you see in the attached picture.

Type in a part number that exists, like 1756-L81E and press search.

Go through the network traffic and you should see a request/response just like the highlighted one. Click in headers and scroll down and you should see the client_id, client_secret, etc... copy those values and type them in the correct place in your local copy of the script.

I remember now running this script on both my Mac at home and Windows PC at work and it worked fine as it was. Maybe it's an issue with the region you're in and where Rockwell directs your request. If this is the case, you should see the website that the request is made to when you click to search.

Hopefully this solves the issue.

On Tue, 13 Aug 2024 at 14:37, ryoshiaki @.***> wrote:

Hi,

Thanks for the reply.

Could you check the secret key? And the other key? Because they are returning error 500 query failure.

Em ter., 13 de ago. de 2024 10:07, bubulindo @.***> escreveu:

Hello,

I had a look now and noticed some other problem, but the main reason it wasn't working was Rockwell changing the site holding the data.

To fix it, replace line 12 of the script from this:

url = " https://es-be-ux-search.cloudhub.io/api/ux/v2/search?queryText="

+

part_number +

"&role=rockwell-search&spellingCorrect=true&spellcheckPremium=10&segments=Productsv4&startIndex=0&numResults=20&facets=&languages=en&locales=en-GB,en_GLOBAL&sort=bma&collections=Literature,Web,Sample_Code&site=RA"

To this:

url = "

https://api.rockwellautomation.com/ra-papi-gsm-search-vpcprod/api/v2/ux/search?queryText="

  • part_number +

"&role=rockwell-search&spellingCorrect=true&spellcheckPremium=10&segments=Productsv4&startIndex=0&numResults=10&facets=&languages=en&locales=en-GB,en_GLOBAL&sort=bma&collections=Literature,Web,Sample_Code&site=RA"

On Mon, 12 Aug 2024 at 22:15, Carlos Cardoso @.***> wrote:

Funny you mention this, I need to look into it for work, I’ll check it tomorrow.

On Mon, 12 Aug 2024 at 20:38, ryoshiaki @.***> wrote:

it's not working anymore any solution?

— Reply to this email directly, view it on GitHub <

https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2284771146>,

or unsubscribe <

https://github.com/notifications/unsubscribe-auth/AAKE6JYA76A3S7EYJCDIAPLZREFJTAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBUG43TCMJUGY>

. You are receiving this because you authored the thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub <

https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2286216833>,

or unsubscribe <

https://github.com/notifications/unsubscribe-auth/BKGDTEFAWT73A36Z2BQYW3DZRIAKNAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBWGIYTMOBTGM>

. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub <

https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2286275278>,

or unsubscribe <

https://github.com/notifications/unsubscribe-auth/AAKE6J37WOLU3EIXHI6V3SLZRIDYBAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBWGI3TKMRXHA>

. You are receiving this because you authored the thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub < https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2287095364>,

or unsubscribe < https://github.com/notifications/unsubscribe-auth/BKGDTED3HXI75WDNMUP3A3DZRJVARAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBXGA4TKMZWGQ>

. You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHub https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2287403783, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAKE6J6KQFCB6X23IWAJU4TZRKLLXAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOBXGQYDGNZYGM . You are receiving this because you authored the thread.Message ID: @.***>

ryoshiaki commented 3 months ago

Hi, Thanks for the answers I was able to do what you wanted with Siemens and with your help I was able to integrate Rockwell as well. Now I have a quick interface for queries.

bubulindo commented 3 months ago

Amazing!! Glad I helped.

On Wed, 14 Aug 2024 at 23:52, ryoshiaki @.***> wrote:

Hi, Thanks for the answers I was able to do what you wanted with Siemens and with your help I was able to integrate Rockwell as well. Now I have a quick interface for queries.

— Reply to this email directly, view it on GitHub https://github.com/bubulindo/RockwellLifeCycle/issues/1#issuecomment-2290075358, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAKE6J7F23ENODJVAMVA4TLZRPNULAVCNFSM6AAAAABMMZ26EKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOJQGA3TKMZVHA . You are receiving this because you authored the thread.Message ID: @.***>