Integration questions

sainath3
Mega Guru

Hi Team,

Am beginner in integration.

Recently I failed in interview.

I want to learn REST API Integration.

Could you please provide answers for below questions ⁉️ 

 

How do you manage sending large amount of data from 3rd party to SNOW?

 

If refresh token is expired how to activate automatically or how resolve the issue?

 

How securly send/keep username and password details to client In Auth2.0 will you ?

 

Can you please send me some integration knowledge documents or interview questions?.

 

 

Thanks & Regards 

Sainath

4 REPLIES 4

Shivalika
Mega Sage

Hello @sainath3 

 

Actually I started integration playlist just 2 weeks back and REST Inbound Integration is complete - Scripted rest API, next I will be sharing SOAP videos. 

So you can surely catch up here - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=cPt8cXOlxBPUq-Ly

 

The scripts PDF are provided in pinned LinkedIn posts. 

LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

 

Now for your 1st question - For huge at one time you can use Default "Import set API" . Otherwise data can be sent to snow - it can be done using POST Operation in REST and SOAP both. 

 

For 2nd, you can use OOB Class GlideOAuthClientAuhProfile and method refresh token to automate it. This script you can write in scheduled job and run it based on the time your token expires. 

 

For 3rd,  to securely keep details you can use  credential aliases to store username and password. And even when you setup OAuth 2.0, it's end to end encrypted. 

 

For 4th Please checkout my linkedin profile, you will get documents for all and also interview questions I will share shortly. 

 

Regards, 

Shivalika 

 

Please accept my solution or mark my answer as helpful if it helped you in anyway 🙂 

tiagomacul
Giga Sage

Integrations in ServiceNow can open up a world of possibilities, but they also come with unique challenges. I know that sometimes you come across situations that require practical and efficient solutions. Let’s unravel three crucial questions that often arise:

how to deal with large volumes of data
how to manage expired refresh tokens
how to secure credentials in OAuth 2.0 integrations.

Get ready to take your knowledge to the next level and turn your challenges into opportunities!

The inspiration for this article came directly from the ServiceNow community, from an insightful question from @sainath3 about interview questions. And make no mistake, these questions are not just theoretical; they reflect the real challenges we face on a daily basis. The ability to handle large volumes of data, credential security, and token management are crucial to the success of any integration.

And speaking of challenges, let’s remember that ServiceNow is an incredibly versatile platform, with countless integration possibilities. The most common, without a doubt, are REST and SOAP integrations. If your external tool communicates through these APIs, the door opens to a world of automation and efficiency. And who knows? Maybe there’s already a ready-made integration in ServiceNow, just waiting for you to configure it.

Let’s explore these possibilities together and find out how to turn your challenges into practical and effective solutions.

Q&A: Practical Solutions for Real Challenges
Let’s get straight to the point and address each of these questions with practical solutions and valuable insights:

How do you manage sending large amounts of data from 3rd party to SNOW?

Handling large volumes of data is a common challenge in integrations. The key here is efficiency and optimization. First, use pagination to break the data into smaller, manageable batches. This reduces the load on the system and avoids timeouts. Second, implement batch processing in ServiceNow to insert or update data efficiently. Use ServiceNow REST APIs with batch operations to minimize the number of calls. Third, consider using MID Server to optimize data transfer, especially if the data is on your internal network. Last but not least, monitor the integration performance and adjust parameters as needed. Remember, optimization is an ongoing process. Test and adjust your strategies to ensure efficient data flow. Note: I skipped the Import mentioned by @shivalika in the post.

If a refresh token is expired, how do you activate it automatically or how resolve the issue? (

If refresh token is expired how to activate automatically or how resolve the issue?)

Expired refresh tokens are a common hurdle in OAuth 2.0 integrations. The best approach is to implement a detection and automatic renewal mechanism. Use scripts in ServiceNow to check the token validity before each API call. If the token is expired, use refresh token to get a new access token. Set up an alert system to notify administrators if automatic renewal fails. Also, implement a manual recovery process for situations where automatic renewal is not possible. Remember: automation is key to a robust integration. Configure your system to handle expired tokens transparently and efficiently. Here are some excellent implementations created together with @Paulo Praxedes2

How do you securely send/keep username and password details to client In Auth2.0 will you ?

Credential security is essential in any integration. In OAuth 2.0, never send credentials directly in the request body or in the URL. Use the authorization code grant flow, which is the most secure. Store credentials encrypted in ServiceNow, using the Credential Store. Use encrypted variables in your code to access credentials. For the client, provide a secure endpoint (HTTPS) so that it can obtain the access token after authorization. Use short-lived access tokens and refresh tokens to minimize the risk of credential exposure. Implement audit logs to monitor access to credentials. Remember, security is a top priority. Follow security best practices to protect your customers’ credentials.

Practical Tips and Best Practices
In addition to specific solutions, I want to share some tips and best practices that can help you deal with these challenges:

Documentation: Maintain complete documentation of all your integrations, including configuration details, data flows, and

tiagomacul_0-1741465179792.jpeg

 

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @sainath3 

 

https://developer.servicenow.com/dev.do#!/reference/api/xanadu/rest/

https://www.servicenow.com/docs/bundle/yokohama-api-reference/page/integrate/inbound-rest/concept/c_...

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Shivalika
Mega Sage

Hello @sainath3 

 

Please check the solutions provided and mark as helpful and accept solution if any helped you. 

 

So that questions can moved from "unsolved" bucket to "solved" one. 

 

Regards, 

Shivalika