{"type":"doc","content":[{"type":"paragraph","content":[{"text":"When integrating with third-party APIs, it's common to fetch data such as access tokens and update them into a database. However, it’s crucial to avoid updating the database with ","type":"text"},{"text":"null","type":"text","marks":[{"type":"code"}]},{"text":" values, especially when the API returns ","type":"text"},{"text":"null","type":"text","marks":[{"type":"code"}]},{"text":" due to issues like downtime or rate limits. Neglecting this can lead to significant issues, including data corruption and unexpected behavior in your application.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Common Pitfall: Updating ","type":"text"},{"text":"null","type":"text","marks":[{"type":"code"}]},{"text":" Values","type":"text"}]},{"type":"paragraph","content":[{"text":"Consider the following code snippet where an access token is fetched from an API and updated into the database. In some cases, the API may return a ","type":"text"},{"text":"null","type":"text","marks":[{"type":"code"}]},{"text":" value, leading to the potential issue of storing a ","type":"text"},{"text":"null","type":"text","marks":[{"type":"code"}]},{"text":" token.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"java"},"content":[{"text":"public Map renewAjioAccessToken(Map queueData) {\n Map ajioGenerateTokenResponse = new HashMap();\n Map newInputFieldsMap = new HashMap<>();\n try {\n // [Extracting connection ID and credentials]\n\n // [Fetching the token from the API]\n int retryCount = 0;\n do {\n retryCount++;\n ajioGenerateTokenResponse = IntegrationTokenGenerationUtil.getAjioAccessTokenGenerateApiResponse(generateTokenCredentials);\n } while (retryCount < 3 && ajioGenerateTokenResponse.get(\"result\") == null);\n\n if (ajioGenerateTokenResponse.get(\"result\") != null) {\n Map result = (Map) ajioGenerateTokenResponse.get(\"result\");\n String token = String.valueOf(result.get(\"accessToken\"));\n // [Other logic]\n\n inputFieldsMap.replace(\"accessToken\", token);\n // [Updating the inputFieldsMap]\n\n newInputFieldsMap.put(key, inputFieldsMap);\n } else {\n logger.severe(\"TOKEN_NOT_GENERATED for queueData: \" + new Gson().toJson(queueData));\n }\n\n // Potential issue: What if newInputFieldsMap is empty due to a null token?\n accessTokenDao.updateTokenDataUsingConnectionId(connectionIdInt, new Gson().toJson(newInputFieldsMap));\n } catch (Exception e) {\n logger.severe(\"ERROR_GENERATING_AJIO_TOKEN: \" + e.toString());\n }\n\n return ajioGenerateTokenResponse;\n}\n","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"},{"type":"hardBreak"},{"text":"In the above code, if the API returns a ","type":"text"},{"text":"null","type":"text","marks":[{"type":"code"}]},{"text":" token, it will still proceed to update the database with potentially ","type":"text"},{"text":"null","type":"text","marks":[{"type":"code"}]},{"text":" or empty data, which can lead to problems later.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Best Practice: Validate Before Updating","type":"text"}]},{"type":"paragraph","content":[{"text":"To prevent this issue, always validate the data before updating it into the database. Here's an improved version of the previous code:","type":"text"},{"type":"hardBreak"},{"type":"hardBreak"}]},{"type":"codeBlock","attrs":{"language":"java"},"content":[{"text":"@Override\npublic Map renewAjioAccessToken(Map queueData) {\n Map ajioGenerateTokenResponse = new HashMap();\n Map newInputFieldsMap = new HashMap<>();\n try {\n // [Extracting connection ID and credentials]\n\n // [Fetching the token from the API]\n int retryCount = 0;\n do {\n retryCount++;\n ajioGenerateTokenResponse = IntegrationTokenGenerationUtil.getAjioAccessTokenGenerateApiResponse(generateTokenCredentials);\n } while (retryCount < 3 && ajioGenerateTokenResponse.get(\"result\") == null);\n\n if (ajioGenerateTokenResponse.get(\"result\") != null) {\n Map result = (Map) ajioGenerateTokenResponse.get(\"result\");\n String token = String.valueOf(result.get(\"accessToken\"));\n // [Other logic]\n\n inputFieldsMap.replace(\"accessToken\", token);\n // [Updating the inputFieldsMap]\n\n newInputFieldsMap.put(key, inputFieldsMap);\n } else {\n logger.severe(\"TOKEN_NOT_GENERATED for queueData: \" + new Gson().toJson(queueData));\n }\n\n // Validate newInputFieldsMap before updating the database\n if (!newInputFieldsMap.isEmpty()) {\n accessTokenDao.updateTokenDataUsingConnectionId(connectionIdInt, new Gson().toJson(newInputFieldsMap));\n // [Cache update logic]\n } else {\n logger.severe(\"TOKEN_NOT_GENERATED for queueData: \" + new Gson().toJson(queueData));\n }\n } catch (Exception e) {\n logger.severe(\"ERROR_GENERATING_AJIO_TOKEN: \" + e.toString());\n }\n\n return ajioGenerateTokenResponse;\n}\n","type":"text"}]}],"version":1}

Browser not supported