How to see all available fields; Salesforce SOQL

 SELECT FIELDS(ALL) FROM ContentDocument

WHERE Id IN ('069ep000006mXXXXXX,'069ep000006mYYYYYY') 

Above SOQL is equivalent of doing

Select * from table in SQL. 

We can filter the required columns on Developer Console. 

Handling JSON Data in OmniScript File Uploads

 While testing File Upload functionality in Salesforce OmniScript, an important limitation was observed during debugging and data handling.

Key Observation

When testing an OmniScript with File Upload, the JSON data is not directly visible in Debug mode. This can be challenging when you need to extract specific attributes from the uploaded file data for use in subsequent OmniScript steps.

Additionally:

• %Data% and %Context% do not work directly when placed in a Text Block after the OmniScript is activated.
• Unlike during preview or debug, activated OmniScripts do not automatically expose the full JSON payload for display.

---

Solution: Use Data Mapper (Transform Action)

To make the required attributes available for downstream processing or display:

• Use a Data Mapper – Transform Action
• Explicitly map the required attributes from the file upload JSON into output nodes
• These mapped outputs can then be referenced reliably in:
  • Subsequent OmniScript elements
  • Integration Procedures
  • Text Blocks or UI components

This approach ensures the needed data is surfaced in a controlled and supported way, instead of relying on raw %Data% or %Context%.

Helpful Reference

Salesforce documentation that explains this behavior and recommended approach in detail:
🔗 Salesforce Help Article
https://help.salesforce.com/s/articleView?id=000391069&type=1

PortQry to check if server is accpting the traffic; Use Case: AWS Machines Unable to Access an Application Link

 

The use case was AWS machines were not able to open a link. We had to request Network Firewall team to enable few subnets and whitelisted to access the link. 

Here’s a corrected, clear, and blog‑ready version with professional flow and concise explanation:

---

Use Case: AWS Machines Unable to Access an Application Link

In this use case, AWS-hosted machines were unable to open a required application link. Initial investigation showed that the application itself was available, but requests from the AWS environment were not reaching the target server.

The issue was identified as a network firewall restriction. The Network/Firewall team was engaged, and specific AWS subnets were enabled and whitelisted to allow outbound access to the application URL. Once the firewall rules were updated, connectivity was restored.

To validate connectivity during troubleshooting, PortQry was used to check whether the target server was accepting traffic on the required port.

PortQry Usage

PortQry is a command-line utility used to verify network connectivity to a specific server and port.

Purpose:

• Confirm whether the target server is reachable
• Identify whether traffic is allowed, blocked, or filtered by a firewall

Example:

portqry.exe -n <target-server> -e <port> -p TCP

If the result shows FILTERED, it typically indicates that a firewall or network security device is blocking the traffic, confirming the need for Network/Firewall team intervention.

SimpliGov - Steps to Navigate to External API End Point