OSDU Software issueshttps://community.opengroup.org/groups/osdu/-/issues2024-03-14T16:17:33Zhttps://community.opengroup.org/osdu/platform/pre-shipping/-/issues/640Ingestion-workflow2024-03-14T16:17:33ZShane HutchinsIngestion-workflowingestion-workflow GET /api/workflow/v1/workflow/name/workflowRun without any runs returns okay.
For example:
```
{
'workflowId': '6bcd6e53-7f9c-4a95-9a07-26beaf696a62',
'workflowName': 'admincli_test',
'description': 'Creat...ingestion-workflow GET /api/workflow/v1/workflow/name/workflowRun without any runs returns okay.
For example:
```
{
'workflowId': '6bcd6e53-7f9c-4a95-9a07-26beaf696a62',
'workflowName': 'admincli_test',
'description': 'Create workflow for test',
'createdBy': 'preshipping_test_user_m19@gcp.gnrg-osdu.projects.epam.com',
'creationTimestamp': 1699897327160,
'version': 1,
'registrationInstructions': {'dagName': 'Osdu_ingest', 'etc': 'AutoTest'}
}
```
However if you add params to the request. For example limit `{'limit': 10}` then /api/workflow/v1/workflow/admincli_test/workflowRun returns a 500
Could only reproduce this on GCP. AWS and Azure not impacted.M21 - Release 0.24Dzmitry Malkevich (EPAM)Shane HutchinsDzmitry Malkevich (EPAM)https://community.opengroup.org/osdu/platform/security-and-compliance/entitlements/-/issues/136[SAST] SQL_Injection in the ClusterGremlinConnector file2023-11-15T10:54:14ZYauhen Shaliou [EPAM/GCP][SAST] SQL_Injection in the ClusterGremlinConnector file<table>
<tr>
<th> </th>
<th>
</th>
<th>Destination</th>
</tr>
<tr>
<th>File</th>
<td>
</td>
<td>entitlements/provider/entitlements-v2-azure/src/main/java/org/opengroup/osdu/entitlements/v2/azure/spi/gremlin/connection/ClusterGremlinCon...<table>
<tr>
<th> </th>
<th>
</th>
<th>Destination</th>
</tr>
<tr>
<th>File</th>
<td>
</td>
<td>entitlements/provider/entitlements-v2-azure/src/main/java/org/opengroup/osdu/entitlements/v2/azure/spi/gremlin/connection/ClusterGremlinConnector.java</td>
</tr>
<tr>
<th>Line number</th>
<td>
</td>
<td>102</td>
</tr>
<tr>
<th>Object</th>
<td>
</td>
<td>getResultList</td>
</tr>
<tr>
<th>Code line</th>
<td>
</td>
<td>return getResultList(client.submit(query));</td>
</tr>
</table>
**Description**
The application's submitTraversalAsQueryString method executes an SQL query with getResultList, at line 102 of \\entitlements\\provider\\entitlements-v2-azure\\src\\main\\java\\org\\opengroup\\osdu\\entitlements\\v2\\azure\\spi\\gremlin\\connection\\ClusterGremlinConnector.java. The application constructs this SQL query by embedding an untrusted string into the query without proper sanitization. The concatenated string is submitted to the database, where it is parsed and executed accordingly.An attacker would be able to inject arbitrary syntax and data into the SQL query, by crafting a malicious payload and providing it via the input groupEmail; this input is then read by the listGroupMembers method at line 58 of \\entitlements\\entitlements-v2-core\\src\\main\\java\\org\\opengroup\\osdu\\entitlements\\v2\\api\\ListMemberApi.java. This input then flows through the code, into a query and to the database server - without sanitization.This may enable an SQL Injection attack.M21 - Release 0.24Srinivasan NarayananSrinivasan Narayananhttps://community.opengroup.org/osdu/platform/system/storage/-/issues/189[SAST] Vue_DOM_XSS in file index.html2023-11-15T10:54:25ZYauhen Shaliou [EPAM/GCP][SAST] Vue_DOM_XSS in file index.html**Description**
The method m-1"\> embeds untrusted data in generated output with href, at line 36 of \\storage\\provider\\storage-azure\\src\\main\\resources\\static\\index.html. This untrusted data is embedded into the output without p...**Description**
The method m-1"\> embeds untrusted data in generated output with href, at line 36 of \\storage\\provider\\storage-azure\\src\\main\\resources\\static\\index.html. This untrusted data is embedded into the output without proper sanitization or encoding, enabling an attacker to inject malicious code into the generated web-page.
# **Location:**
<table>
<tr>
<th> </th>
<th>Source</th>
<th>Destination</th>
</tr>
<tr>
<th>File</th>
<td>storage/provider/storage-azure/src/main/resources/static/index.html</td>
<td>storage/provider/storage-azure/src/main/resources/static/index.html</td>
</tr>
<tr>
<th>Line number</th>
<td>92</td>
<td>36</td>
</tr>
<tr>
<th>Object</th>
<td>pathname</td>
<td>href</td>
</tr>
<tr>
<th>Code line</th>
<td>return location.protocol + '//' + location.host + location.pathname</td>
<td>
\<a :href="signInUrl" class="btn btn-primary" v-if="!token" class="col-2"\>Login\</a\>
</td>
</tr>
</table>M21 - Release 0.24https://community.opengroup.org/osdu/platform/system/register/-/issues/48Subscription Verification Request Incorrectly Encoded2023-10-30T21:06:16ZDerek HudsonSubscription Verification Request Incorrectly EncodedSubscription verification request (the request that the Register service sends to verify that a Push endpoint is valid) improperly encodes the `hmac` query string parameter, which allows raw `=` in the `hmac` query string parameter, whic...Subscription verification request (the request that the Register service sends to verify that a Push endpoint is valid) improperly encodes the `hmac` query string parameter, which allows raw `=` in the `hmac` query string parameter, which in tern can cause subscription creation to fail.
Testing a fix locally before publishing.M21 - Release 0.24Derek HudsonDerek Hudsonhttps://community.opengroup.org/osdu/platform/pre-shipping/-/issues/615Discrepancy in Retrieval Instructions Output for FileCollection.Generic in GC...2024-02-08T12:24:47ZNisha ThakranDiscrepancy in Retrieval Instructions Output for FileCollection.Generic in GCP (M20)The output from the "Get Retrieval Instructions" request (step 5 of Postman Collection under Datasets) should ideally include the "retrievalPropertiesList" with a corresponding "signedURL" for seamless file download according to the prev...The output from the "Get Retrieval Instructions" request (step 5 of Postman Collection under Datasets) should ideally include the "retrievalPropertiesList" with a corresponding "signedURL" for seamless file download according to the previous test results. (https://community.opengroup.org/osdu/platform/pre-shipping/-/blob/M20-EDS-DOC/R3-M19/Test_plan_Results_M19/Core_services/M19_gcp_TestDatasetFileCollection_workflow.txt#L207).
However the current response is different.
screen shot is attached:
![image](/uploads/ecff9ecac100ecffb84847868a9795ac/image.png)
postman collection : https://community.opengroup.org/osdu/platform/pre-shipping/-/blob/main/R3-M18/GCP-M18/GCP_OSDU_Smoke_Tests.postman_collection.jsonM21 - Release 0.24Denis Karpenok (EPAM)Dzmitry Malkevich (EPAM)Nisha ThakranDenis Karpenok (EPAM)https://community.opengroup.org/osdu/platform/security-and-compliance/entitlements/-/issues/135Tenant deprovisioning API2023-11-02T04:28:51ZHimanshu KumrawatTenant deprovisioning API# Problem Statement
Currently Entitlements API’s in OSDU lack the direct functionality of clearing all the entitlements respective to a partition. There’s no dedicated API exposed which can perform exhaustive cleaning or removing all th...# Problem Statement
Currently Entitlements API’s in OSDU lack the direct functionality of clearing all the entitlements respective to a partition. There’s no dedicated API exposed which can perform exhaustive cleaning or removing all the entitlements. There is a gap in terms of functionality for the use case in which all the groups, including bootstrapped groups, and all their members can be removed in one go. There is no API which does the opposite to what the tenant-provisioning API does. There are some endpoints exposed to get the desired functionality iteratively deleting each group and their respective members but there is no possible way to clear out all the entitlements for a partition using a single endpoint. The delete group API only clears one group at a time. The delete member API cleans all the association of the user from associated groups and then removes the member.
Therefore, the users and CSPs, when required, cannot clear out all the entitlements of a partition and to bridge this gap there’s a need to extend the set of APIs exposed currently by adding one with the capability of cleaning the entitlements end to end for a respective partition.
Adding to the requirement the availability of the new functionality will help all the CSP’s to efficiently manage the entitlements on data partition level.
# Rationale behind the proposal
In future if OSDU wants to add support for deleting the data partition this feature will be very helpful in its implementation. While cleaning the resources corresponding to a data partition being deleted all the entitlements can be removed with a call to single API.
# Proposals
## API Design:
A new entitlement API is proposed to provide the tenant de-provisioning functionality. This API shall be capable of removing all the entitlement groups of the partition internally by removing the data from the CSP respective databases. This API should be deleting all the groups including bootstrap groups and deleting all the members of the respective groups also. There should be complete disassociation of members belonging to the data partition given as input to API. On completion of deletion activity, the rest-API need to provide with appropriate status-code for success or failure.
The user with valid access token is permitted to call the API. The permitted token needs to be a valid admin app token only, no other token shall be allowed to access the API restricting the admin users to perform the cleaning of the entitlements. This restriction is like the authentication in case of tenant-provisioning allowing only the OSDU admin to perform the critical operations. The new endpoint can be same as tenant-provisioning update with delete method.
### API Signature:
HOST URL: {{endpoint}}/api/entitlements/v2/tenant-provisioning
headers = {
'data-partition-id': data-partition-name,
'Content-Type': 'application/json',
'Authorization': Bearer \<token\>
}
method = 'DELETE'
The above API can be implemented by providing definition to the following interface associated with the controller for the tenant deprovisioning. The deprovisionTenant functionality must clear all the entitlement’s groups and all members before returning.
package org.opengroup.osdu.entitlements.v2.service;\
\
public interface TenantDeprovisioningService {\
_/\*\*\
\* In case of unexpected error all changes made are reverted. \
\*/_
void deprovisionTenant();\
}
### Api Controller
Following controller change need to be added to make use of the definition provided as follow:
@RestController\
public class InitApi {\
\
@Autowired\
private TenantInitService tenantInitService;\
\
@Autowired\
private TenantDeprovisioningService tenantDeprovisioningService;
@PostMapping("/tenant-provisioning")\
@PreAuthorize("@authorizationFilter.hasAnyPermission()")\
public ResponseEntity\<InitServiceDto\> initiateTenant(@RequestBody(required = false) InitServiceDto initServiceDto) {\
tenantInitService.createDefaultGroups();\
tenantInitService.bootstrapInitialAccounts(initServiceDto);\
return new ResponseEntity\<\>(initServiceDto, HttpStatus._OK_);\
}\
\
@DeleteMapping("/tenant-provisioning")\
@PreAuthorize("@authorizationFilter.hasAnyPermission()")\
public ResponseEntity\<Void\> deleteTenant(@RequestBody(required = false) DeleteServiceDto deleteServiceDto) {\
tenantDeprovisioningService.deprovisionTenant();\
return new ResponseEntity\<\>(HttpStatus._NO_CONTENT_);\
}\
}
## Flow Diagram
![image.png](/uploads/7bf2f2df216a19377fb2a862889676a5/image.png)
## FAQ
1. The delete API will be a synchronous call and can this be done in a few seconds?
A. Yes, it will be a sync call only, and will be completed within seconds.M21 - Release 0.24Himanshu KumrawatHimanshu Kumrawat2023-09-11https://community.opengroup.org/osdu/platform/data-flow/ingestion/osdu-airflow-lib/-/issues/7Static analyzer fails in EDS operators2023-09-20T05:19:39ZYan Sushchynski (EPAM)Static analyzer fails in EDS operatorsJob [#2183134](https://community.opengroup.org/osdu/platform/data-flow/ingestion/osdu-airflow-lib/-/jobs/2183134) failed for b2fb09af463e7d884562ea6ae89535a11eaa552f:
Could I ask you have a look at the failed job?Job [#2183134](https://community.opengroup.org/osdu/platform/data-flow/ingestion/osdu-airflow-lib/-/jobs/2183134) failed for b2fb09af463e7d884562ea6ae89535a11eaa552f:
Could I ask you have a look at the failed job?M21 - Release 0.24Ashish SaxenaJeyakumar DevarajuluAshish Saxenahttps://community.opengroup.org/osdu/platform/domain-data-mgmt-services/reservoir/open-etp-client/-/issues/19Standardization of endpoints2023-11-09T14:26:30ZChad LeongStandardization of endpoints# Summary
Based on the recent M19 pre-shipping testing, we identified a few discrepancies in the Reservoir DDMS endpoints for both ETP and REST servers. We need to follow the standard convention of OSDU.
## Actual behavior
These are t...# Summary
Based on the recent M19 pre-shipping testing, we identified a few discrepancies in the Reservoir DDMS endpoints for both ETP and REST servers. We need to follow the standard convention of OSDU.
## Actual behavior
These are the endpoints observed today.
ETP Server:
- [AWS] wss://osdu.r3m18.preshiptesting.osdu.aws/api/oreservoir-ddms-etp/v2/
- [Azure] wss://osdu-ship.msft-osdu-test.org/oetp/reservoir-ddms/
- [Google] wss://preship.gcp.gnrg-osdu.projects.epam.com/api/oetp-server/v2/
- [IBM] ?
REST Server:
- [AWS] https://osdu.r3m18.preshiptesting.osdu.aws/api/reservoir-ddms/v2
- [Azure] https://osdu-ship.msft-osdu-test.org/api/oetp-client/v2
- [Google] https://preship.gcp.gnrg-osdu.projects.epam.com/api/reservoir-ddms/v2
- [IBM] ?
## Intended behavior
We should follow the standard endpoint convention in OSDU.
ETP Server:
- `{baserurl}/api/reservoir-ddms-etp/v2/`
REST server:
- `{baserurl}/api/reservoir-ddms/v2/{methods}`
## Pending Implementation
- [X] AWS
- [ ] Azure
- [X] GC
- [ ] IBMM21 - Release 0.24https://community.opengroup.org/osdu/platform/data-flow/ingestion/osdu-airflow-lib/-/issues/6Need longer waiting time within EDS.2023-09-22T13:57:53ZBruce JinNeed longer waiting time within EDS.In EDS ingestion, it will wait 60 seconds for manifest ingestion dag to ramp up. But sometimes the 60s is not enough for the ingestion dag to update a task_status if the processing data is very big. As a result the EDS_ingest dag will fa...In EDS ingestion, it will wait 60 seconds for manifest ingestion dag to ramp up. But sometimes the 60s is not enough for the ingestion dag to update a task_status if the processing data is very big. As a result the EDS_ingest dag will fail, even the manifest_ingestion is actually succeeded.
Highly recommend to extend the waiting time, or make it adjustable.M21 - Release 0.24Nisha ThakranPriyanka BhongadeBruce JinNisha Thakranhttps://community.opengroup.org/osdu/platform/system/schema-service/-/issues/124Schema service upgrades may be blocked by schemas created in private tenants.2023-10-12T13:30:24ZRustam Lotsmanenko (EPAM)rustam_lotsmanenko@epam.comSchema service upgrades may be blocked by schemas created in private tenants.Currently, the creation of system schema may be blocked by the private internal schema in a private tenant.
If schema initially were created in the private tenant.
![Untitled_Diagram.drawio](/uploads/990837be38e4c62e3f0dbb257d914eb7/U...Currently, the creation of system schema may be blocked by the private internal schema in a private tenant.
If schema initially were created in the private tenant.
![Untitled_Diagram.drawio](/uploads/990837be38e4c62e3f0dbb257d914eb7/Untitled_Diagram.drawio.png)
**Cons of current flow:**
- Easy to break bootstrapping, it will fail with errors like: `Error with kind osdu:wks:master-data--ConnectedSourceDataJob:1.3.0: Message: Update/Create failed because schema id is present in another tenant`
- It's not possible to fix it through API, since Schema doesn't have a DELETE endpoint.
**Proposal:**
- There is none for now.
**Additional info:**M21 - Release 0.24Rustam Lotsmanenko (EPAM)rustam_lotsmanenko@epam.comRustam Lotsmanenko (EPAM)rustam_lotsmanenko@epam.comhttps://community.opengroup.org/osdu/platform/domain-data-mgmt-services/rock-and-fluid-sample/rafs-ddms-services/-/issues/123Prepare consistent service bootstrapping testing dataset2023-10-12T15:14:03ZSiarhei Khaletski (EPAM)Prepare consistent service bootstrapping testing dataset## Context
Nearly all OSDU services require bootstrapping datasets to verify service correctness after deployment.
Some of them require schemas uploading to the Schema service, others require master data and reference data upload, etc.
...## Context
Nearly all OSDU services require bootstrapping datasets to verify service correctness after deployment.
Some of them require schemas uploading to the Schema service, others require master data and reference data upload, etc.
## Scope
The team has already prepared testing Postman Collection (https://community.opengroup.org/osdu/qa/-/tree/main/Dev/48_CICD_Setup_RAFSDDMSAPI)
It requires a careful review by SME to ensure that the dataset is consistent:
1. Source files (XLS, PDF) are valid and publicly available, or (given authorization) are sanitized of any identifying information to ensure they do not violate any IP rights
2. Datasets describe (meta-data) related to their respective source files
3. Derived meta-data from the source files are inserted into the proper WPC (within the testing Postman Collection)
4. Derived bulk-data from the source files are inserted into the /data endpoints.
The goal is to have a clear and consistent chain of `source file` -> `source file dataset` -> `WPC` -> `bulk Data`.
Note: preliminary steps for registration source file datasets must be added to the project README file.RAFS DDMS Sprint 19Michael JonesMichael Joneshttps://community.opengroup.org/osdu/platform/consumption/geospatial/-/issues/315Remove callback url from gcz Authentication implementation2023-11-17T16:14:58ZAnkita SrivastavaRemove callback url from gcz Authentication implementationRemove callback url from gcz Authentication implementationRemove callback url from gcz Authentication implementationGCZ Sprint 53https://community.opengroup.org/osdu/platform/pre-shipping/-/issues/690M22 AZURE - Not Able to Retrieve Subproject Metadata2024-02-15T13:56:20ZJuliana Fernandesjuliana.fernandes@iesbrazil.com.brM22 AZURE - Not Able to Retrieve Subproject MetadataHello,
I'm trying to create a **new subproject via postman** and retrieve the subproject metadata but I'm getting status 403 Forbidden (Step 5). Other thing I've noticed is when I List the subproject in a tenant, even with a legal that...Hello,
I'm trying to create a **new subproject via postman** and retrieve the subproject metadata but I'm getting status 403 Forbidden (Step 5). Other thing I've noticed is when I List the subproject in a tenant, even with a legal that in the body for the subproject creation (Step 4), the created project does not have a legal tag associated (Step6). What could be wrong?
Here is what I'm doing:
- Collection: [Azure_OSDU_Smoke_Tests.postman_collection.json](https://community.opengroup.org/osdu/platform/pre-shipping/-/blob/main/R3-M22/Azure-M22/Services/Smoke-tests/Azure_OSDU_Smoke_Tests.postman_collection.json?ref_type=heads)
- Environment: [Verify_Preshipping_New_TeamA-E.postman_environment.json](https://community.opengroup.org/osdu/platform/pre-shipping/-/blob/main/R3-M22/Azure-M22/Environment/Verify_Preshipping_New_TeamA-E.postman_environment.json?ref_type=heads)
## 1. Create a Legal Tag
POST https://{{LEGAL_HOST}}/legaltags
**BODY CURL VERSION**
```
curl --location 'https://osdu-ship.msft-osdu-test.org/api/legal/v1/legaltags' \
--header 'Content-Type: application/json' \
--header 'data-partition-id: opendes' \
--header 'Authorization: Bearer <Token>' \
--data '{
"name": "opendes-SeismicDMS-Legal-Tag-Test9295727",
"description": "Legal Tag added for VDS to VDS testing",
"properties": {
"contractId": "123456",
"countryOfOrigin": [
"US",
"CA"
],
"dataType": "Public Domain Data",
"exportClassification": "EAR99",
"originator": "Schlumberger",
"personalData": "No Personal Data",
"securityClassification": "public",
"expirationDate": "2025-12-25"
}
}'
```
**BODY**
```json
{
"name": "{{tagName}}",
"description": "Legal Tag added for VDS to VDS testing",
"properties": {
"contractId": "123456",
"countryOfOrigin": [
"US",
"CA"
],
"dataType": "Public Domain Data",
"exportClassification": "EAR99",
"originator": "Schlumberger",
"personalData": "No Personal Data",
"securityClassification": "public",
"expirationDate": "2025-12-25"
}
}
```
**RESPONSE**
```json
{
"name": "opendes-SeismicDMS-Legal-Tag-Test9295727",
"description": "Legal Tag added for VDS to VDS testing",
"properties": {
"countryOfOrigin": [
"US",
"CA"
],
"contractId": "123456",
"expirationDate": "2025-12-25",
"originator": "Schlumberger",
"dataType": "Public Domain Data",
"securityClassification": "public",
"personalData": "No Personal Data",
"exportClassification": "EAR99"
}
}
```
## 2. Register a new tenant
POST https://{{SEISMICDMS_HOST}}/tenant/{{data-partition-id}}
**BODY CURL VERSION**
```
curl --location 'https://osdu-ship.msft-osdu-test.org/seistore-svc/api/v3/tenant/opendes' \
--header 'Content-Type: application/json' \
--header 'data-partition-id: opendes' \
--header 'Authorization: Bearer <Token>' \
--data-raw '{
"gcpid": "AutoTest_project_id",
"esd": "opendes.contoso.com",
"default_acl": "users.datalake.admins@opendes.contoso.com"
}'
```
**BODY**
```json
{
"gcpid": "AutoTest_project_id",
"esd": "{{data-partition-id}}{{domain}}",
"default_acl": "users.datalake.admins@{{data-partition-id}}{{domain}}"
}
```
**RESPONSE**
```
[seismic-store-service] The tenant opendes has been registered already
```
## 3. Retrieve Tenant Metadata
GET https://{{SEISMICDMS_HOST}}/tenant/{{data-partition-id}}
**BODY CURL VERSION**
```
curl --location 'https://osdu-ship.msft-osdu-test.org/seistore-svc/api/v3/tenant/opendes' \
--header 'Content-Type: application/json' \
--header 'data-partition-id: opendes' \
--header 'Authorization: Bearer <Token>'
```
**RESPONSE**
```json
{
"name": "opendes",
"esd": "opendes.contoso.com",
"gcpid": "AutoTest_project_id",
"default_acls": "users.datalake.admins@opendes.contoso.com"
}
```
## 4. Create a new subproject
POST https://{{SEISMICDMS_HOST}}/subproject/tenant/{{data-partition-id}}/subproject/{{subprojectid}}
**BODY CURL VERSION**
```
curl --location 'https://osdu-ship.msft-osdu-test.org/seistore-svc/api/v3/subproject/tenant/opendes/subproject/subprojectodi595608' \
--header 'Content-Type: application/json' \
--header 'data-partition-id: opendes' \
--header 'ltag;' \
--header 'Authorization: Bearer <Token>' \
--data-raw '{
"admin": "admin@opendes.contoso.com",
"storage_class": "MULTI_REGIONAL",
"storage_location": "US",
"acls": {
"admins": [
"data.sdms.opendes.subprojectodi595608.admin@opendes.contoso.com"
],
"viewers": [
"data.sdms.opendes.subprojectodi595608.viewer@opendes.contoso.com"
]
},
"legal": {
"legaltags": [
"opendes-SeismicDMS-Legal-Tag-Test1358259"
],
"otherRelevantDataCountries": [
"US"
]
}
}'
```
**BODY**
```
{
"admin": "admin@{{data-partition-id}}{{domain}}",
"storage_class": "MULTI_REGIONAL",
"storage_location": "US",
"acls": {
"admins": [
"data.sdms.{{autotestTenantid}}.{{subprojectid}}.admin@{{data-partition-id}}{{domain}}"
],
"viewers": [
"data.sdms.{{autotestTenantid}}.{{subprojectid}}.viewer@{{data-partition-id}}{{domain}}"
]
},
"legal": {
"legaltags": [
"{{tagName}}"
],
"otherRelevantDataCountries": [
"US"
]
}
}
```
**RESPONSE**
```
PASS Status code is 200
PASS Status description - OK
subprojectid - subprojectodi595608 (Additional Information, was not in the response body)
```
## 5. Retrieve subproject metadata
GET https://{{SEISMICDMS_HOST}}/subproject/tenant/{{data-partition-id}}/subproject/{{subprojectid}}
**BODY CURL VERSION**
```
curl --location 'https://subproject/tenant/opendes/subproject/subprojectodi595608' \
--header 'Content-Type: application/json' \
--header 'data-partition-id: opendes' \
--header 'Authorization: Bearer <Token>'
```
**RESPONSE**
```
[seismic-store-service] User not authorized to perform this operation
Status: 403 Forbiden
```
## 6. List subproject in a tenant
GET https://{{SEISMICDMS_HOST}}/subproject/tenant/{{data-partition-id}}
**BODY CURL VERSION**
```
curl --location 'https://osdu-ship.msft-osdu-test.org/seistore-svc/api/v3/subproject/tenant/opendes' \
--header 'Content-Type: application/json' \
--header 'data-partition-id: opendes' \
--header 'Authorization: Bearer <Token>'
```
**RESPONSE**
```json
{
"name": "subprojectodi595608",
"tenant": "opendes",
"ltag": "",
"acls": {
"admins": [
"data.sdms.opendes.subprojectodi595608.admin@opendes.contoso.com"
],
"viewers": [
"data.sdms.opendes.subprojectodi595608.viewer@opendes.contoso.com"
]
},
"access_policy": "uniform",
"enforce_key": true,
"gcs_bucket": "ss-cloud-kwgbwij7gyjh488"
}
```
Regards,
JulianaM22 - Release 0.25Om Prakash GuptaOm Prakash Guptahttps://community.opengroup.org/osdu/platform/pre-shipping/-/issues/685AWS M22 - Core Services - Augmented Index2024-02-08T15:46:31ZJuliana Fernandesjuliana.fernandes@iesbrazil.com.brAWS M22 - Core Services - Augmented IndexHello, I'm trying to Reindex Well Records but the request does not stop to run and I don't get any result.
So far, this is what I've done:
- Collection: [AWS_OSDUR3M22_CoreServices_Collection.postman_collection.json](https://community.o...Hello, I'm trying to Reindex Well Records but the request does not stop to run and I don't get any result.
So far, this is what I've done:
- Collection: [AWS_OSDUR3M22_CoreServices_Collection.postman_collection.json](https://community.opengroup.org/osdu/platform/pre-shipping/-/blob/main/R3-M22/AWS-M22/Core%20Services/AWS_OSDUR3M22_CoreServices_Collection.postman_collection.json?ref_type=heads)
- Environment: [AWS_M22_preshipping_environment.json](https://community.opengroup.org/osdu/platform/pre-shipping/-/blob/main/R3-M22/AWS-M22/Environment/AWS_M22_preshipping_environment.json?ref_type=heads)
## 1. Create record using Storage
PUT {{osduonaws_base_url}}/api/storage/v2/records
**BODY CURL VERSION**
```
curl --location --request PUT 'https://prsh.testing.preshiptesting.osdu.aws/api/storage/v2/records' \
--header 'Content-Type: application/json' \
--header 'data-partition-id: osdu' \
--header 'Authorization: Bearer <Token>' \
--data-raw '[
{
"data": {
"DefaultVerticalMeasurementID": "Rotary Table",
"ExtensionProperties": {
"CustomField1": "JFA01262024"
},
"FacilityEvents": [
{
"EffectiveDateTime": "2002-05-12T00:00:00",
"FacilityEventTypeID": "osdu:reference-data--FacilityEventType:SPUD:"
},
{
"EffectiveDateTime": "2002-06-07T00:00:00",
"FacilityEventTypeID": "osdu:reference-data--FacilityEventType:DRILLING%20FINISH:"
}
],
"FacilityID": "A14-02-test",
"FacilityOperators": [
{
"FacilityOperatorOrganisationID": "osdu:master-data--Organisation:NAM:"
}
],
"FacilityStates": [
{
"FacilityStateTypeID": "osdu:reference-data--FacilityStateType:Abandoned:"
}
],
"FacilityTypeID": "osdu:reference-data--FacilityType:A14-02:",
"GeoContexts": [
{
"GeoPoliticalEntityID": "osdu:master-data--GeoPoliticalEntity:Netherlands:",
"GeoTypeID": "osdu:reference-data--GeoPoliticalEntityType:Country:"
},
{
"GeoPoliticalEntityID": "osdu:master-data--GeoPoliticalEntity:A14:",
"GeoTypeID": "osdu:reference-data--GeoPoliticalEntityType:BlockID:"
}
],
"NameAliases": [
{
"AliasName": "A14-02-test",
"AliasNameTypeID": "osdu:reference-data--AliasNameType:WELL_NAME:"
},
{
"AliasName": "8577-test",
"AliasNameTypeID": "osdu:reference-data--AliasNameType:UWI:"
}
],
"OperatingEnvironmentID": "osdu:reference-data--OperatingEnvironment:OFF:",
"Source": "TNO",
"SpatialLocation": {
"Wgs84Coordinates": {
"features": [
{
"geometry": {
"coordinates": [
3.39488769,
55.32443529
],
"type": "Point"
},
"properties": {},
"type": "Feature"
}
],
"type": "FeatureCollection"
}
},
"VerticalMeasurements": [
{
"VerticalCRSID": "osdu:reference-data--CoordinateReferenceSystem:MSL:",
"VerticalMeasurement": 39.2,
"VerticalMeasurementID": "Rotary Table",
"VerticalMeasurementPathID": "osdu:reference-data--VerticalMeasurementPath:Elevation:",
"VerticalMeasurementUnitOfMeasureID": "osdu:reference-data--UnitOfMeasure:M:"
}
]
},
"meta": [],
"kind": "osdu:wks:master-data--Well:1.0.0",
"id": "osdu:master-data--Well:JFA29JAN",
"acl": {
"viewers": [
"data.default.viewers@osdu.example.com"
],
"owners": [
"data.default.owners@osdu.example.com"
]
},
"legal": {
"legaltags": [
"osdu-public-usa-dataset-osduonaws-jfa-01-26-2024"
],
"otherRelevantDataCountries": [
"US"
],
"status": "compliant"
}
}
]'
```
**BODY**
```json
[
{
"data": {
"DefaultVerticalMeasurementID": "Rotary Table",
"ExtensionProperties": {
"CustomField1": "JFA01262024"
},
"FacilityEvents": [
{
"EffectiveDateTime": "2002-05-12T00:00:00",
"FacilityEventTypeID": "osdu:reference-data--FacilityEventType:SPUD:"
},
{
"EffectiveDateTime": "2002-06-07T00:00:00",
"FacilityEventTypeID": "osdu:reference-data--FacilityEventType:DRILLING%20FINISH:"
}
],
"FacilityID": "A14-02-test",
"FacilityOperators": [
{
"FacilityOperatorOrganisationID": "osdu:master-data--Organisation:NAM:"
}
],
"FacilityStates": [
{
"FacilityStateTypeID": "osdu:reference-data--FacilityStateType:Abandoned:"
}
],
"FacilityTypeID": "osdu:reference-data--FacilityType:A14-02:",
"GeoContexts": [
{
"GeoPoliticalEntityID": "osdu:master-data--GeoPoliticalEntity:Netherlands:",
"GeoTypeID": "osdu:reference-data--GeoPoliticalEntityType:Country:"
},
{
"GeoPoliticalEntityID": "osdu:master-data--GeoPoliticalEntity:A14:",
"GeoTypeID": "osdu:reference-data--GeoPoliticalEntityType:BlockID:"
}
],
"NameAliases": [
{
"AliasName": "A14-02-test",
"AliasNameTypeID": "osdu:reference-data--AliasNameType:WELL_NAME:"
},
{
"AliasName": "8577-test",
"AliasNameTypeID": "osdu:reference-data--AliasNameType:UWI:"
}
],
"OperatingEnvironmentID": "osdu:reference-data--OperatingEnvironment:OFF:",
"Source": "TNO",
"SpatialLocation": {
"Wgs84Coordinates": {
"features": [
{
"geometry": {
"coordinates": [
3.39488769,
55.32443529
],
"type": "Point"
},
"properties": {},
"type": "Feature"
}
],
"type": "FeatureCollection"
}
},
"VerticalMeasurements": [
{
"VerticalCRSID": "osdu:reference-data--CoordinateReferenceSystem:MSL:",
"VerticalMeasurement": 39.2,
"VerticalMeasurementID": "Rotary Table",
"VerticalMeasurementPathID": "osdu:reference-data--VerticalMeasurementPath:Elevation:",
"VerticalMeasurementUnitOfMeasureID": "osdu:reference-data--UnitOfMeasure:M:"
}
]
},
"meta": [],
"kind": "osdu:wks:master-data--Well:1.0.0",
"id": "osdu:master-data--Well:JFA29JAN",
"acl": {
"viewers": [
"data.default.viewers@osdu.example.com"
],
"owners": [
"data.default.owners@osdu.example.com"
]
},
"legal": {
"legaltags": [
"osdu-public-usa-dataset-osduonaws-jfa-01-26-2024"
],
"otherRelevantDataCountries": [
"US"
],
"status": "compliant"
}
}
]
```
**RESPONSE**
```json
{
"recordCount": 1,
"recordIds": [
"osdu:master-data--Well:JFA29JAN"
],
"skippedRecordIds": [],
"recordIdVersions": [
"osdu:master-data--Well:JFA29JAN:1706533127863414"
]
}
```
## 2. Create Augmented Index
PUT {{osduonaws_base_url}}/api/storage/v2/records
**BODY CURL VERSION**
```
curl --location --request PUT 'https://prsh.testing.preshiptesting.osdu.aws/api/storage/v2/records' \
--header 'Content-Type: application/json' \
--header 'data-partition-id: osdu' \
--header 'Authorization: Bearer <Token>' \
--data-raw '[
{
"data": {
"Name": "Agreement-IndexPropertyPathConfiguration",
"Description": "valid for all master-data--Well kinds for major version 1.",
"Code": "osdu:wks:master-data--Well:1.",
"AttributionAuthority": "OSDU",
"Configurations": [
{
"Name": "UWI-JFA",
"Policy": "ExtractFirstMatch",
"Paths": [
{
"ValueExtraction": {
"RelatedConditionMatches": [
"osdu:reference-data--AliasNameType:UWI:"
],
"RelatedConditionProperty": "data.NameAliases[].AliasNameTypeID",
"ValuePath": "data.NameAliases[].AliasName"
}
}
],
"UseCase": "As a user I want to discover and match Well records by their UWI value."
}
]
},
"meta": [],
"id": "osdu:reference-data--IndexPropertyPathConfiguration:wks:master-data--Well:1.",
"kind": "osdu:wks:reference-data--IndexPropertyPathConfiguration:1.0.0",
"acl": {
"viewers": [
"data.default.viewers@osdu.example.com"
],
"owners": [
"data.default.owners@osdu.example.com"
]
},
"legal": {
"legaltags": [
"osdu-public-usa-dataset-osduonaws-jfa-01-26-2024"
],
"otherRelevantDataCountries": [
"US"
],
"status": "compliant"
}
}
]'
```
**BODY**
```json
[
{
"data": {
"Name": "Agreement-IndexPropertyPathConfiguration",
"Description": "valid for all master-data--Well kinds for major version 1.",
"Code": "osdu:wks:master-data--Well:1.",
"AttributionAuthority": "OSDU",
"Configurations": [
{
"Name": "UWI-JFA",
"Policy": "ExtractFirstMatch",
"Paths": [
{
"ValueExtraction": {
"RelatedConditionMatches": [
"{{data_partition_id}}:reference-data--AliasNameType:UWI:"
],
"RelatedConditionProperty": "data.NameAliases[].AliasNameTypeID",
"ValuePath": "data.NameAliases[].AliasName"
}
}
],
"UseCase": "As a user I want to discover and match Well records by their UWI value."
}
]
},
"meta": [],
"id": "osdu:reference-data--IndexPropertyPathConfiguration:wks:master-data--Well:1.",
"kind": "osdu:wks:reference-data--IndexPropertyPathConfiguration:1.0.0",
"acl": {
"viewers": [
"data.default.viewers@osdu.example.com"
],
"owners": [
"data.default.owners@osdu.example.com"
]
},
"legal": {
"legaltags": [
"osdu-public-usa-dataset-osduonaws-jfa-01-26-2024"
],
"otherRelevantDataCountries": [
"US"
],
"status": "compliant"
}
}
]
```
**RESPONSE**
```json
{
"recordCount": 1,
"recordIds": [
"osdu:reference-data--IndexPropertyPathConfiguration:wks:master-data--Well:1."
],
"skippedRecordIds": [],
"recordIdVersions": [
"osdu:reference-data--IndexPropertyPathConfiguration:wks:master-data--Well:1.:1706533183016537"
]
}
```
## 3. Reindex Well records
POST {{INDEXER_HOST}}/reindex?force_clean=true
**BODY CURL VERSION**
```
curl --location 'https://prsh.testing.preshiptesting.osdu.aws/api/indexer/v2/reindex?force_clean=true' \
--header 'data-partition-id: osdu' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer <Token>' \
--data '{
"kind": "osdu:wks:master-data--Well:1.0.0"
}'
```
**BODY**
```json
{
"kind": "osdu:wks:master-data--Well:1.0.0"
}
```
**RESPONSE**
```
Status: Unknown Time:5m 58.02s (Still running)
```
![Captura_de_tela_2024-01-29_100626](/uploads/8d30521560ac88be75b1ca6431eea227/Captura_de_tela_2024-01-29_100626.png)
Regards,
JulianaM22 - Release 0.25https://community.opengroup.org/osdu/platform/pre-shipping/-/issues/683Unable to download the file using signedurl2024-02-26T14:32:34ZMohd Asad ShaikhUnable to download the file using signedurlI was able to perform all steps for creation of WPC and trying to read the content of the file using the signedurl given in this docs "https://community.opengroup.org/osdu/platform/pre-shipping/-/tree/main/R3-M17/Test_Plan_Results_M17/ED...I was able to perform all steps for creation of WPC and trying to read the content of the file using the signedurl given in this docs "https://community.opengroup.org/osdu/platform/pre-shipping/-/tree/main/R3-M17/Test_Plan_Results_M17/EDS" where source was AWS and target was Azure it works as Expected.
But when i tried these steps by making source as GC and destination as Azure, it gives error on step number 10 in attached document.
Here we are trying to read the content of the file using the signedurl But not able to download the file gives 404 error .
[M22-Azure-EDS-wpc-from-GCP-ASD.docx](/uploads/d28a775bb5077231dabc2d08b153963f/M22-Azure-EDS-wpc-from-GCP-ASD.docx)M22 - Release 0.25Yan Sushchynski (EPAM)Dzmitry Malkevich (EPAM)Yan Sushchynski (EPAM)https://community.opengroup.org/osdu/platform/pre-shipping/-/issues/682IBM M22 - Core Services - CRS Conversion V32024-02-07T07:01:55ZJuliana Fernandesjuliana.fernandes@iesbrazil.com.brIBM M22 - Core Services - CRS Conversion V3Hello,
I'm trying to run 2 requests for CRS Conversion V3 without Success.
here is what I have:
- Collection: [CRS Conversion Service V3 CI-CD v1.0.postman_collection.json](https://community.opengroup.org/osdu/platform/pre-shipping/-...Hello,
I'm trying to run 2 requests for CRS Conversion V3 without Success.
here is what I have:
- Collection: [CRS Conversion Service V3 CI-CD v1.0.postman_collection.json](https://community.opengroup.org/osdu/platform/pre-shipping/-/blob/main/R3-M22/QA_Artifacts_M22/envFilesAndCollections/CRS%20Conversion%20Service%20V3%20CI-CD%20v1.0.postman_collection.json?ref_type=heads)
- Environment: [OSDU_R3_IBM_ODI_M22_ENV.postman_environment.json](https://community.opengroup.org/osdu/platform/pre-shipping/-/blob/main/R3-M22/IBM-M22/Environment/OSDU_R3_IBM_ODI_M22_ENV.postman_environment.json?ref_type=heads)
## 2. Convert a list of points
POST https://{{CRS_CONVERSION_HOST_V3}}/convert
**BODY CURL VERSION**
```
curl --location 'https://cpd-osdu.apps.osdu-preship.ibmodi.com/osdu-crs-conversion/api/crs/converter/v3/convert' \
--header 'data-partition-id: opendes' \
--header 'Content-Type: application/json' \
--header 'Accept: application/json' \
--header 'Authorization: Bearer <Token>' \
--header 'Cookie: 5e7c4a992d2558462d1c9fcde6f1cee7=d7c00795bd9f4e77085f06413828a62c' \
--data '{
"fromCRS": "opendes:reference-data--CoordinateReferenceSystem:BoundProjected:EPSG::28992_EPSG::1672:",
"toCRS": "opendes:reference-data--CoordinateReferenceSystem:Projected:EPSG::32632:",
"points": [
{
"x": 400000,
"y": 190000,
"z": 0
},
{
"x": 399787.00835051807,
"y": 6500567.67783067,
"z": -173.79810638019308
}
]
}'
```
**BODY**
```json
{
"fromCRS": "{{data-partition-id}}:reference-data--CoordinateReferenceSystem:BoundProjected:EPSG::28992_EPSG::1672:",
"toCRS": "{{data-partition-id}}:reference-data--CoordinateReferenceSystem:Projected:EPSG::32632:",
"points": [
{
"x": 400000,
"y": 190000,
"z": 0
},
{
"x": 399787.00835051807,
"y": 6500567.67783067,
"z": -173.79810638019308
}
]
}
```
**RESPONSE**
```json
{
"code": 400,
"message": "record not found: opendes:reference-data--CoordinateReferenceSystem:BoundProjected:EPSG::28992_EPSG::1672/"
}
```
## 3. Convert Bin Grid
POST https://{{CRS_CONVERSION_HOST_V3}}/convertBinGrid
**BODY CURL VERSION**
```
curl --location 'https://cpd-osdu.apps.osdu-preship.ibmodi.com/osdu-crs-conversion/api/crs/converter/v3/convertBinGrid' \
--header 'data-partition-id: opendes' \
--header 'Content-Type: application/json' \
--header 'Accept: application/json' \
--header 'Authorization: Bearer <Token>' \
--header 'Cookie: 5e7c4a992d2558462d1c9fcde6f1cee7=d7c00795bd9f4e77085f06413828a62c' \
--data '{
"toCRS": "opendes:reference-data--CoordinateReferenceSystem:BoundProjected:EPSG::32064_EPSG::15851:",
"inBinGrid": {
"CoveragePercent": 1.0,
"ABCDBinGridSpatialLocation": {
"AsIngestedCoordinates": {
"type": "AnyCrsFeatureCollection",
"CoordinateReferenceSystemID": "opendes:reference-data--CoordinateReferenceSystem:Projected:EPSG::32615:",
"features": [
{
"type": "AnyCrsFeature",
"properties": {
"Kind": "osdu:osdu:AbstractGeoJson.PropertiesBinGridCorners:1.0.0",
"PointProperties": [
{
"Inline": 1,
"Crossline": 1000
}
]
},
"geometry": {
"type": "AnyCrsPoint",
"coordinates": [
500000.00,
3000000.00
]
}
},
{
"type": "AnyCrsFeature",
"properties": {
"Kind": "osdu:osdu:AbstractGeoJson.PropertiesBinGridCorners:1.0.0",
"PointProperties": [
{
"Inline": 1,
"Crossline": 2000
}
]
},
"geometry": {
"type": "AnyCrsPoint",
"coordinates": [
500000.00,
3100000.00
]
}
},
{
"type": "AnyCrsFeature",
"properties": {
"Kind": "osdu:osdu:AbstractGeoJson.PropertiesBinGridCorners:1.0.0",
"PointProperties": [
{
"Inline": 101,
"Crossline": 1000
}
]
},
"geometry": {
"type": "AnyCrsPoint",
"coordinates": [
600000.00,
3000000.00
]
}
},
{
"type": "AnyCrsFeature",
"properties": {
"Kind": "osdu:osdu:AbstractGeoJson.PropertiesBinGridCorners:1.0.0",
"PointProperties": [
{
"Inline": 101,
"Crossline": 2000
}
]
},
"geometry": {
"type": "AnyCrsPoint",
"coordinates": [
600000.00,
3100000.00
]
}
}
]
}
},
"P6ScaleFactorOfBinGrid": 1,
"P6BinNodeIncrementOnIaxis": 1,
"P6BinNodeIncrementOnJaxis": 1
}
}'
```
**BODY**
```json
{
"toCRS": "{{data-partition-id}}:reference-data--CoordinateReferenceSystem:BoundProjected:EPSG::32064_EPSG::15851:",
"inBinGrid": {
"CoveragePercent": 1.0,
"ABCDBinGridSpatialLocation": {
"AsIngestedCoordinates": {
"type": "AnyCrsFeatureCollection",
"CoordinateReferenceSystemID": "{{data-partition-id}}:reference-data--CoordinateReferenceSystem:Projected:EPSG::32615:",
"features": [
{
"type": "AnyCrsFeature",
"properties": {
"Kind": "{{authority}}:{{schemaSource}}:AbstractGeoJson.PropertiesBinGridCorners:1.0.0",
"PointProperties": [
{
"Inline": 1,
"Crossline": 1000
}
]
},
"geometry": {
"type": "AnyCrsPoint",
"coordinates": [
500000.00,
3000000.00
]
}
},
{
"type": "AnyCrsFeature",
"properties": {
"Kind": "{{authority}}:{{schemaSource}}:AbstractGeoJson.PropertiesBinGridCorners:1.0.0",
"PointProperties": [
{
"Inline": 1,
"Crossline": 2000
}
]
},
"geometry": {
"type": "AnyCrsPoint",
"coordinates": [
500000.00,
3100000.00
]
}
},
{
"type": "AnyCrsFeature",
"properties": {
"Kind": "{{authority}}:{{schemaSource}}:AbstractGeoJson.PropertiesBinGridCorners:1.0.0",
"PointProperties": [
{
"Inline": 101,
"Crossline": 1000
}
]
},
"geometry": {
"type": "AnyCrsPoint",
"coordinates": [
600000.00,
3000000.00
]
}
},
{
"type": "AnyCrsFeature",
"properties": {
"Kind": "{{authority}}:{{schemaSource}}:AbstractGeoJson.PropertiesBinGridCorners:1.0.0",
"PointProperties": [
{
"Inline": 101,
"Crossline": 2000
}
]
},
"geometry": {
"type": "AnyCrsPoint",
"coordinates": [
600000.00,
3100000.00
]
}
}
]
}
},
"P6ScaleFactorOfBinGrid": 1,
"P6BinNodeIncrementOnIaxis": 1,
"P6BinNodeIncrementOnJaxis": 1
}
}
```
**RESPONSE**
```json
{
"code": 400,
"message": "record not found: opendes:reference-data--CoordinateReferenceSystem:BoundProjected:EPSG::32064_EPSG::15851/"
}
```M22 - Release 0.25Ashwani PandeyAshwani Pandeyhttps://community.opengroup.org/osdu/platform/pre-shipping/-/issues/677IBM M22 - Core Services - Register and Notification2024-01-24T19:40:47ZJuliana Fernandesjuliana.fernandes@iesbrazil.com.brIBM M22 - Core Services - Register and NotificationHello,
I'm trying to do the Register and notification but I was not able to find any collection for Register.
This feature is enabled for IBM?
Also IBM is able to provide some documentation/clarification for Notification?
Regards,
Jul...Hello,
I'm trying to do the Register and notification but I was not able to find any collection for Register.
This feature is enabled for IBM?
Also IBM is able to provide some documentation/clarification for Notification?
Regards,
JulianaM22 - Release 0.25https://community.opengroup.org/osdu/platform/pre-shipping/-/issues/676Azure M22 - Core Services - Register and Notification2024-01-29T11:45:03ZJuliana Fernandesjuliana.fernandes@iesbrazil.com.brAzure M22 - Core Services - Register and NotificationHello,
I'm trying to do the Register and notification but I was not able to find any collection for Register.
This feature is enabled for Azure?
Also Azure is able to provide some documentation/clarification for Notification?
Regards,
...Hello,
I'm trying to do the Register and notification but I was not able to find any collection for Register.
This feature is enabled for Azure?
Also Azure is able to provide some documentation/clarification for Notification?
Regards,
JulianaM22 - Release 0.25Om Prakash GuptaOm Prakash Guptahttps://community.opengroup.org/osdu/platform/pre-shipping/-/issues/674GC M22 - Core Services - Search "AsIngestedCoordinates" not returning2024-01-29T15:53:54ZJuliana Fernandesjuliana.fernandes@iesbrazil.com.brGC M22 - Core Services - Search "AsIngestedCoordinates" not returningHello,
I'm trying to complete the the task **Search shows AsIngested** from pre-shipping and I'm not getting the expected result.
First I need to Get the record and this one shows AsIngestedCoordinates, but when I search it does not ap...Hello,
I'm trying to complete the the task **Search shows AsIngested** from pre-shipping and I'm not getting the expected result.
First I need to Get the record and this one shows AsIngestedCoordinates, but when I search it does not appear.
So I made a search for the AsIngestedCoordinates without success and finally made a search to look for the AsIngestedCoordinates in a record without success to...
What it's happening?
Debasis posted an example for AWS, here: https://community.opengroup.org/osdu/platform/pre-shipping/-/blob/main/R3-M22/Test_plan_Results_M22/Core%20Services/M22-AWS-Core-Services-search-returns-AsIngested-coordinates-Debasis.docx?ref_type=heads
Here is what I'm doing for Search shows AsIngested:
- Collection: [GC_OSDU_Smoke_Tests.postman_collection.json](https://community.opengroup.org/osdu/platform/pre-shipping/-/blob/main/R3-M22/GC-M22/GC_OSDU_Smoke_Tests.postman_collection.json)
- Environment: [OSDU_R3_GC_Pre-ship.postman_environment.json](https://community.opengroup.org/osdu/platform/pre-shipping/-/blob/main/R3-M22/GC-M22/OSDU_R3_GC_Pre-ship.postman_environment.json)
## 1. GET the Record
GET https://{{STORAGE_HOST}}/records/m19:master-data--Wellbore:9254
**BODY CURL VERSION**
```
curl --location 'https://preship.gcp.gnrg-osdu.projects.epam.com/api/storage/v2/records/m19:master-data--Wellbore:9254' \
--header 'data-partition-id: m19' \
--header 'Authorization: Bearer <Token>'
```
**RESPONSE**
```json
{
"data": {
"CurrentOperatorID": "m19:master-data--Organisation:Total%20E%26P%20Nederland%20B.V.:",
"DefaultVerticalMeasurementID": "Measured_From",
"DrillingReasons": [
{
"DrillingReasonTypeID": "m19:reference-data--DrillingReasonType:EXP-HC:"
}
],
"FacilityEvents": [
{
"EffectiveDateTime": "1995-12-09T00:00:00",
"FacilityEventTypeID": "m19:reference-data--FacilityEventType:Sidetrack:"
},
{
"EffectiveDateTime": "1996-02-17T00:00:00",
"FacilityEventTypeID": "m19:reference-data--FacilityEventType:TDReached:"
}
],
"FacilityName": "9254",
"FacilityStates": [
{
"FacilityStateTypeID": "m19:reference-data--FacilityStateType:ShutIn:"
}
],
"FacilityTypeID": "m19:reference-data--FacilityType:Wellbore:",
"GeoContexts": [
{
"GeoPoliticalEntityID": "m19:master-data--GeoPoliticalEntity:K04_BlockID:",
"GeoTypeID": "m19:reference-data--GeoPoliticalEntityType:BlockID:"
},
{
"FieldID": "m19:master-data--Field:K04-A:",
"GeoTypeID": "Field"
}
],
"InitialOperatorID": "m19:master-data--Organisation:Elf%20Petroland:",
"NameAliases": [
{
"AliasName": "9254",
"AliasNameTypeID": "m19:reference-data--AliasNameType:UWI:"
},
{
"AliasName": "K04-09B-S2",
"AliasNameTypeID": "m19:reference-data--AliasNameType:BoreholeCode:"
},
{
"AliasName": "K04-09B-SIDETRACK2",
"AliasNameTypeID": "m19:reference-data--AliasNameType:Borehole:"
}
],
"OperatingEnvironmentID": "m19:reference-data--OperatingEnvironment:Off:",
"PrimaryMaterialID": "m19:reference-data--MaterialType:Gas:",
"ProjectedBottomHoleLocation": {
"AsIngestedCoordinates": {
"CoordinateReferenceSystemID": "m19:reference-data--CoordinateReferenceSystem:23031:",
"features": [
{
"geometry": {
"coordinates": [
517701.0,
5957457.0
],
"type": "AnyCrsPoint"
},
"properties": {},
"type": "AnyCrsFeature"
}
],
"persistableReferenceCrs": "{\"authCode\":{\"auth\":\"EPSG\",\"code\":\"23031\"},\"name\":\"ED_1950_UTM_Zone_31N\",\"type\":\"LBC\",\"ver\":\"PE_10_3_1\",\"wkt\":\"PROJCS[\\\"ED_1950_UTM_Zone_31N\\\",GEOGCS[\\\"GCS_European_1950\\\",DATUM[\\\"D_European_1950\\\",SPHEROID[\\\"International_1924\\\",6378388.0,297.0]],PRIMEM[\\\"Greenwich\\\",0.0],UNIT[\\\"Degree\\\",0.0174532925199433]],PROJECTION[\\\"Transverse_Mercator\\\"],PARAMETER[\\\"False_Easting\\\",500000.0],PARAMETER[\\\"False_Northing\\\",0.0],PARAMETER[\\\"Central_Meridian\\\",3.0],PARAMETER[\\\"Scale_Factor\\\",0.9996],PARAMETER[\\\"Latitude_Of_Origin\\\",0.0],UNIT[\\\"Meter\\\",1.0],AUTHORITY[\\\"EPSG\\\",23031]]\"}",
"type": "AnyCrsFeatureCollection"
}
},
"SequenceNumber": 3,
"SpatialLocation": {
"AsIngestedCoordinates": {
"CoordinateReferenceSystemID": "m19:reference-data--CoordinateReferenceSystem:23031:",
"features": [
{
"geometry": {
"coordinates": [
520507.0,
5955994.0
],
"type": "AnyCrsPoint"
},
"properties": {},
"type": "AnyCrsFeature"
}
],
"persistableReferenceCrs": "{\"authCode\":{\"auth\":\"EPSG\",\"code\":\"23031\"},\"name\":\"ED_1950_UTM_Zone_31N\",\"type\":\"LBC\",\"ver\":\"PE_10_3_1\",\"wkt\":\"PROJCS[\\\"ED_1950_UTM_Zone_31N\\\",GEOGCS[\\\"GCS_European_1950\\\",DATUM[\\\"D_European_1950\\\",SPHEROID[\\\"International_1924\\\",6378388.0,297.0]],PRIMEM[\\\"Greenwich\\\",0.0],UNIT[\\\"Degree\\\",0.0174532925199433]],PROJECTION[\\\"Transverse_Mercator\\\"],PARAMETER[\\\"False_Easting\\\",500000.0],PARAMETER[\\\"False_Northing\\\",0.0],PARAMETER[\\\"Central_Meridian\\\",3.0],PARAMETER[\\\"Scale_Factor\\\",0.9996],PARAMETER[\\\"Latitude_Of_Origin\\\",0.0],UNIT[\\\"Meter\\\",1.0],AUTHORITY[\\\"EPSG\\\",23031]]\"}",
"type": "AnyCrsFeatureCollection"
},
"Wgs84Coordinates": {
"features": [
{
"geometry": {
"coordinates": [
3.30959248,
53.75027988
],
"type": "Point"
},
"properties": {},
"type": "Feature"
}
],
"type": "FeatureCollection"
}
},
"TrajectoryTypeID": "m19:reference-data--WellboreTrajectoryType:Deviated:",
"VerticalMeasurements": [
{
"VerticalMeasurement": 5193.0,
"VerticalMeasurementID": "TD-Original",
"VerticalMeasurementPathID": "m19:reference-data--VerticalMeasurementPath:MD:",
"VerticalMeasurementTypeID": "m19:reference-data--VerticalMeasurementType:TD:",
"VerticalReferenceID": "Measured_From"
},
{
"VerticalMeasurement": 3887.61,
"VerticalMeasurementID": "TVD",
"VerticalMeasurementPathID": "m19:reference-data--VerticalMeasurementPath:TVD:",
"VerticalMeasurementTypeID": "m19:reference-data--VerticalMeasurementType:TD:",
"VerticalReferenceID": "Measured_From"
},
{
"VerticalCRSID": "m19:reference-data--CoordinateReferenceSystem:MSL:",
"VerticalMeasurement": 40.0,
"VerticalMeasurementID": "Measured_From",
"VerticalMeasurementPathID": "m19:reference-data--VerticalMeasurementPath:Elevation:",
"VerticalMeasurementTypeID": "m19:reference-data--VerticalMeasurementType:RotaryTable:"
}
],
"WellID": "m19:master-data--Well:8988:"
},
"meta": [
{
"kind": "Unit",
"name": "m",
"persistableReference": "{\"abcd\":{\"a\":0.0,\"b\":1.0,\"c\":1.0,\"d\":0.0},\"symbol\":\"m\",\"baseMeasurement\":{\"ancestry\":\"L\",\"type\":\"UM\"},\"type\":\"UAD\"}",
"propertyNames": [
"VerticalMeasurements[].VerticalMeasurement"
],
"unitOfMeasureID": "m19:reference-data--UnitOfMeasure:m:"
}
],
"id": "m19:master-data--Wellbore:9254",
"version": 1689778069245048,
"kind": "osdu:wks:master-data--Wellbore:1.0.0",
"acl": {
"viewers": [
"data.default.viewers@m19.group"
],
"owners": [
"data.default.owners@m19.group"
]
},
"legal": {
"legaltags": [
"m19-default-data-tag"
],
"otherRelevantDataCountries": [
"US"
],
"status": "compliant"
},
"createUser": "datafier@osdu-service-prod.iam.gserviceaccount.com",
"createTime": "2023-07-19T14:47:50.784Z"
}
```
## 2. Search the Record
### You should see AsIngested coordinates in the response.
POST {{SEARCH_HOST}}/query
**BODY CURL VERSION**
```
curl --location 'https://preship.gcp.gnrg-osdu.projects.epam.com/api/search/v2/query' \
--header 'Authorization: Bearer <Token>' \
--header 'data-partition-id: m19' \
--header 'Content-Type: application/json' \
--data '{
"kind": "osdu:wks:master-data--Wellbore:*",
"query": "id: \"m19:master-data--Wellbore:9254\""
}'
```
**BODY**
```json
{
"kind": "{{authority}}:{{schemaSource}}:master-data--Wellbore:*",
"query": "id: \"m19:master-data--Wellbore:9254\""
}
```
**RESPONSE**
```json
{
"results": [
{
"data": {
"VirtualProperties.DefaultLocation.QuantitativeAccuracyBandID": null,
"DefaultVerticalMeasurementID": "Measured_From",
"ResourceCurationStatus": null,
"FacilityName": "9254",
"DrillingReasons": [
{
"DrillingReasonTypeID": "m19:reference-data--DrillingReasonType:EXP-HC:"
}
],
"VirtualProperties.DefaultName": "9254",
"VirtualProperties.DefaultLocation.CoordinateQualityCheckPerformedBy": null,
"ResourceSecurityClassification": null,
"SequenceNumber": 3,
"DataSourceOrganisationID": null,
"SpatialLocation.SpatialParameterTypeID": null,
"ExistenceKind": null,
"FacilityTypeID": "m19:reference-data--FacilityType:Wellbore:",
"FacilityEvents": [
{
"EffectiveDateTime": "1995-12-09T00:00:00+0000",
"FacilityEventTypeID": "m19:reference-data--FacilityEventType:Sidetrack:"
},
{
"EffectiveDateTime": "1996-02-17T00:00:00+0000",
"FacilityEventTypeID": "m19:reference-data--FacilityEventType:TDReached:"
}
],
"VirtualProperties.DefaultLocation.IsDecimated": false,
"ProjectedBottomHoleLocation.QuantitativeAccuracyBandID": null,
"CurrentOperatorID": "m19:master-data--Organisation:Total%20E%26P%20Nederland%20B.V.:",
"ProjectedBottomHoleLocation.SpatialGeometryTypeID": null,
"SpatialLocation.SpatialGeometryTypeID": null,
"OperatingEnvironmentID": "m19:reference-data--OperatingEnvironment:Off:",
"ProjectedBottomHoleLocation.QualitativeSpatialAccuracyTypeID": null,
"GeographicBottomHoleLocation.QuantitativeAccuracyBandID": null,
"PrimaryMaterialID": "m19:reference-data--MaterialType:Gas:",
"VirtualProperties.DefaultLocation.QualitativeSpatialAccuracyTypeID": null,
"InitialOperatorID": "m19:master-data--Organisation:Elf%20Petroland:",
"GeographicBottomHoleLocation.SpatialGeometryTypeID": null,
"WellID": "m19:master-data--Well:8988:",
"FacilityStates": [
{
"FacilityStateTypeID": "m19:reference-data--FacilityStateType:ShutIn:"
}
],
"GeographicBottomHoleLocation.SpatialParameterTypeID": null,
"GeographicBottomHoleLocation.CoordinateQualityCheckPerformedBy": null,
"ResourceLifecycleStatus": null,
"TargetFormation": null,
"SpatialLocation.Wgs84Coordinates": {
"geometries": [
{
"coordinates": [
3.30959248,
53.75027988
],
"type": "point"
}
],
"type": "geometrycollection"
},
"TechnicalAssuranceID": null,
"VirtualProperties.DefaultLocation.SpatialGeometryTypeID": null,
"Source": null,
"DefinitiveTrajectoryID": null,
"FacilityID": null,
"GeographicBottomHoleLocation.QualitativeSpatialAccuracyTypeID": null,
"VerticalMeasurements": [
{
"WellboreTVDTrajectoryID": null,
"VerticalCRSID": null,
"VerticalMeasurementSourceID": null,
"VerticalReferenceID": "Measured_From",
"VerticalMeasurementID": "TD-Original",
"VerticalMeasurementPathID": "m19:reference-data--VerticalMeasurementPath:MD:",
"VerticalMeasurement": 5193.0,
"VerticalMeasurementTypeID": "m19:reference-data--VerticalMeasurementType:TD:",
"VerticalMeasurementDescription": null,
"VerticalMeasurementUnitOfMeasureID": null
},
{
"WellboreTVDTrajectoryID": null,
"VerticalCRSID": null,
"VerticalMeasurementSourceID": null,
"VerticalReferenceID": "Measured_From",
"VerticalMeasurementID": "TVD",
"VerticalMeasurementPathID": "m19:reference-data--VerticalMeasurementPath:TVD:",
"VerticalMeasurement": 3887.61,
"VerticalMeasurementTypeID": "m19:reference-data--VerticalMeasurementType:TD:",
"VerticalMeasurementDescription": null,
"VerticalMeasurementUnitOfMeasureID": null
},
{
"WellboreTVDTrajectoryID": null,
"VerticalCRSID": "m19:reference-data--CoordinateReferenceSystem:MSL:",
"VerticalMeasurementSourceID": null,
"VerticalReferenceID": null,
"VerticalMeasurementID": "Measured_From",
"VerticalMeasurementPathID": "m19:reference-data--VerticalMeasurementPath:Elevation:",
"VerticalMeasurement": 40.0,
"VerticalMeasurementTypeID": "m19:reference-data--VerticalMeasurementType:RotaryTable:",
"VerticalMeasurementDescription": null,
"VerticalMeasurementUnitOfMeasureID": null
}
],
"VersionCreationReason": null,
"KickOffWellbore": null,
"SpatialLocation.CoordinateQualityCheckPerformedBy": null,
"NameAliases": [
{
"AliasName": "9254",
"AliasNameTypeID": "m19:reference-data--AliasNameType:UWI:",
"DefinitionOrganisationID": null
},
{
"AliasName": "K04-09B-S2",
"AliasNameTypeID": "m19:reference-data--AliasNameType:BoreholeCode:",
"DefinitionOrganisationID": null
},
{
"AliasName": "K04-09B-SIDETRACK2",
"AliasNameTypeID": "m19:reference-data--AliasNameType:Borehole:",
"DefinitionOrganisationID": null
}
],
"ProjectedBottomHoleLocation.CoordinateQualityCheckPerformedBy": null,
"GeoContexts": [
{
"BasinID": null,
"FieldID": null,
"PlayID": null,
"GeoPoliticalEntityID": "m19:master-data--GeoPoliticalEntity:K04_BlockID:",
"GeoTypeID": "m19:reference-data--GeoPoliticalEntityType:BlockID:",
"ProspectID": null
},
{
"BasinID": null,
"FieldID": "m19:master-data--Field:K04-A:",
"PlayID": null,
"GeoPoliticalEntityID": null,
"GeoTypeID": "Field",
"ProspectID": null
}
],
"ProjectedBottomHoleLocation.SpatialParameterTypeID": null,
"SpatialLocation.QualitativeSpatialAccuracyTypeID": null,
"VirtualProperties.DefaultLocation.SpatialParameterTypeID": null,
"ResourceHomeRegionID": null,
"VirtualProperties.DefaultLocation.Wgs84Coordinates": {
"geometries": [
{
"coordinates": [
3.30959248,
53.75027988
],
"type": "point"
}
],
"type": "geometrycollection"
},
"SpatialLocation.QuantitativeAccuracyBandID": null,
"TrajectoryTypeID": "m19:reference-data--WellboreTrajectoryType:Deviated:"
},
"kind": "osdu:wks:master-data--Wellbore:1.0.0",
"source": "wks",
"acl": {
"viewers": [
"data.default.viewers@m19.group"
],
"owners": [
"data.default.owners@m19.group"
]
},
"type": "master-data--Wellbore",
"version": 1689778069245048,
"tags": {
"normalizedKind": "osdu:wks:master-data--Wellbore:1"
},
"createTime": "2023-07-19T14:47:50.784Z",
"authority": "osdu",
"namespace": "osdu:wks",
"legal": {
"legaltags": [
"m19-dataimport-legaltag"
],
"otherRelevantDataCountries": [
"US"
],
"status": "compliant"
},
"createUser": "datafier@osdu-service-prod.iam.gserviceaccount.com",
"id": "m19:master-data--Wellbore:9254"
}
],
"aggregations": null,
"phraseSuggestions": [],
"totalCount": 1
}
```
When I Search for AsIngestedCoordinates I get an empty result:
## Serch AsIngestedCoordinates
POST https://{{SEARCH_HOST}}/query
**BODY CURL VERSION**
```
curl --location 'https://preship.gcp.gnrg-osdu.projects.epam.com/api/search/v2/query' \
--header 'Authorization: Bearer <Token>' \
--header 'data-partition-id: m19' \
--header 'Content-Type: application/json' \
--data '{
"kind": ["osdu:wks:master-data--Wellbore:*"],
"returnedFields": ["id", "data.SpatialLocation", "data.FacilityName"],
"query":
"data.SpatialLocation.AsIngestedCoordinates.CoordinateReferenceSystemID:\"m19:reference-data--CoordinateReferenceSystem:23031:\""
}'
```
**BODY**
```json
{
"kind": ["{{authority}}:{{schemaSource}}:master-data--Wellbore:*"],
"returnedFields": ["id", "data.SpatialLocation", "data.FacilityName"],
"query":
"data.SpatialLocation.AsIngestedCoordinates.CoordinateReferenceSystemID:\"m19:reference-data--CoordinateReferenceSystem:23031:\""
}
```
**RESPONSE**
```json
{
"results": [],
"aggregations": [],
"phraseSuggestions": [],
"totalCount": 0
}
```
To make sure the AsIngestedCoordinates exist I made the following search and didn't found it:
## Search for AsIngestedCoordinates in the Record
POST https://{{SEARCH_HOST}}/query
**BODY CURL VERSION**
```
curl --location 'https://preship.gcp.gnrg-osdu.projects.epam.com/api/search/v2/query' \
--header 'Authorization: Bearer <Token>' \
--header 'data-partition-id: m19' \
--header 'Content-Type: application/json' \
--data '{
"kind": "osdu:*:master-data--Wellbore:*",
"offset": 0,
"limit": 1,
"trackTotalCount": true,
"highlightedFields": ["id", "data.ProjectedBottomHoleLocation.AsIngestedCoordinates", "data.FacilityName", "kind"]
}'
```
**BODY**
```json
{
"kind": "osdu:*:master-data--Wellbore:*",
"offset": 0,
"limit": 1,
"trackTotalCount": true,
"highlightedFields": ["id", "data.ProjectedBottomHoleLocation.AsIngestedCoordinates", "data.FacilityName", "kind"]
}
```
**RESPONSE**
```json
{
"results": [
{
"data": {
"VirtualProperties.DefaultLocation.QuantitativeAccuracyBandID": null,
"DefaultVerticalMeasurementID": "Measured_From",
"ResourceCurationStatus": null,
"FacilityName": "9254",
"DrillingReasons": [
{
"DrillingReasonTypeID": "m19:reference-data--DrillingReasonType:EXP-HC:"
}
],
"VirtualProperties.DefaultName": "9254",
"VirtualProperties.DefaultLocation.CoordinateQualityCheckPerformedBy": null,
"ResourceSecurityClassification": null,
"SequenceNumber": 3,
"DataSourceOrganisationID": null,
"SpatialLocation.SpatialParameterTypeID": null,
"ExistenceKind": null,
"FacilityTypeID": "m19:reference-data--FacilityType:Wellbore:",
"FacilityEvents": [
{
"EffectiveDateTime": "1995-12-09T00:00:00+0000",
"FacilityEventTypeID": "m19:reference-data--FacilityEventType:Sidetrack:"
},
{
"EffectiveDateTime": "1996-02-17T00:00:00+0000",
"FacilityEventTypeID": "m19:reference-data--FacilityEventType:TDReached:"
}
],
"VirtualProperties.DefaultLocation.IsDecimated": false,
"ProjectedBottomHoleLocation.QuantitativeAccuracyBandID": null,
"CurrentOperatorID": "m19:master-data--Organisation:Total%20E%26P%20Nederland%20B.V.:",
"ProjectedBottomHoleLocation.SpatialGeometryTypeID": null,
"SpatialLocation.SpatialGeometryTypeID": null,
"OperatingEnvironmentID": "m19:reference-data--OperatingEnvironment:Off:",
"ProjectedBottomHoleLocation.QualitativeSpatialAccuracyTypeID": null,
"GeographicBottomHoleLocation.QuantitativeAccuracyBandID": null,
"PrimaryMaterialID": "m19:reference-data--MaterialType:Gas:",
"VirtualProperties.DefaultLocation.QualitativeSpatialAccuracyTypeID": null,
"InitialOperatorID": "m19:master-data--Organisation:Elf%20Petroland:",
"GeographicBottomHoleLocation.SpatialGeometryTypeID": null,
"WellID": "m19:master-data--Well:8988:",
"FacilityStates": [
{
"FacilityStateTypeID": "m19:reference-data--FacilityStateType:ShutIn:"
}
],
"GeographicBottomHoleLocation.SpatialParameterTypeID": null,
"GeographicBottomHoleLocation.CoordinateQualityCheckPerformedBy": null,
"ResourceLifecycleStatus": null,
"TargetFormation": null,
"SpatialLocation.Wgs84Coordinates": {
"geometries": [
{
"coordinates": [
3.30959248,
53.75027988
],
"type": "point"
}
],
"type": "geometrycollection"
},
"TechnicalAssuranceID": null,
"VirtualProperties.DefaultLocation.SpatialGeometryTypeID": null,
"Source": null,
"DefinitiveTrajectoryID": null,
"FacilityID": null,
"GeographicBottomHoleLocation.QualitativeSpatialAccuracyTypeID": null,
"VerticalMeasurements": [
{
"WellboreTVDTrajectoryID": null,
"VerticalCRSID": null,
"VerticalMeasurementSourceID": null,
"VerticalReferenceID": "Measured_From",
"VerticalMeasurementID": "TD-Original",
"VerticalMeasurementPathID": "m19:reference-data--VerticalMeasurementPath:MD:",
"VerticalMeasurement": 5193.0,
"VerticalMeasurementTypeID": "m19:reference-data--VerticalMeasurementType:TD:",
"VerticalMeasurementDescription": null,
"VerticalMeasurementUnitOfMeasureID": null
},
{
"WellboreTVDTrajectoryID": null,
"VerticalCRSID": null,
"VerticalMeasurementSourceID": null,
"VerticalReferenceID": "Measured_From",
"VerticalMeasurementID": "TVD",
"VerticalMeasurementPathID": "m19:reference-data--VerticalMeasurementPath:TVD:",
"VerticalMeasurement": 3887.61,
"VerticalMeasurementTypeID": "m19:reference-data--VerticalMeasurementType:TD:",
"VerticalMeasurementDescription": null,
"VerticalMeasurementUnitOfMeasureID": null
},
{
"WellboreTVDTrajectoryID": null,
"VerticalCRSID": "m19:reference-data--CoordinateReferenceSystem:MSL:",
"VerticalMeasurementSourceID": null,
"VerticalReferenceID": null,
"VerticalMeasurementID": "Measured_From",
"VerticalMeasurementPathID": "m19:reference-data--VerticalMeasurementPath:Elevation:",
"VerticalMeasurement": 40.0,
"VerticalMeasurementTypeID": "m19:reference-data--VerticalMeasurementType:RotaryTable:",
"VerticalMeasurementDescription": null,
"VerticalMeasurementUnitOfMeasureID": null
}
],
"VersionCreationReason": null,
"KickOffWellbore": null,
"SpatialLocation.CoordinateQualityCheckPerformedBy": null,
"NameAliases": [
{
"AliasName": "9254",
"AliasNameTypeID": "m19:reference-data--AliasNameType:UWI:",
"DefinitionOrganisationID": null
},
{
"AliasName": "K04-09B-S2",
"AliasNameTypeID": "m19:reference-data--AliasNameType:BoreholeCode:",
"DefinitionOrganisationID": null
},
{
"AliasName": "K04-09B-SIDETRACK2",
"AliasNameTypeID": "m19:reference-data--AliasNameType:Borehole:",
"DefinitionOrganisationID": null
}
],
"ProjectedBottomHoleLocation.CoordinateQualityCheckPerformedBy": null,
"GeoContexts": [
{
"BasinID": null,
"FieldID": null,
"PlayID": null,
"GeoPoliticalEntityID": "m19:master-data--GeoPoliticalEntity:K04_BlockID:",
"GeoTypeID": "m19:reference-data--GeoPoliticalEntityType:BlockID:",
"ProspectID": null
},
{
"BasinID": null,
"FieldID": "m19:master-data--Field:K04-A:",
"PlayID": null,
"GeoPoliticalEntityID": null,
"GeoTypeID": "Field",
"ProspectID": null
}
],
"ProjectedBottomHoleLocation.SpatialParameterTypeID": null,
"SpatialLocation.QualitativeSpatialAccuracyTypeID": null,
"VirtualProperties.DefaultLocation.SpatialParameterTypeID": null,
"ResourceHomeRegionID": null,
"VirtualProperties.DefaultLocation.Wgs84Coordinates": {
"geometries": [
{
"coordinates": [
3.30959248,
53.75027988
],
"type": "point"
}
],
"type": "geometrycollection"
},
"SpatialLocation.QuantitativeAccuracyBandID": null,
"TrajectoryTypeID": "m19:reference-data--WellboreTrajectoryType:Deviated:"
},
"kind": "osdu:wks:master-data--Wellbore:1.0.0",
"source": "wks",
"acl": {
"viewers": [
"data.default.viewers@m19.group"
],
"owners": [
"data.default.owners@m19.group"
]
},
"type": "master-data--Wellbore",
"version": 1689778069245048,
"tags": {
"normalizedKind": "osdu:wks:master-data--Wellbore:1"
},
"createTime": "2023-07-19T14:47:50.784Z",
"authority": "osdu",
"namespace": "osdu:wks",
"legal": {
"legaltags": [
"m19-dataimport-legaltag"
],
"otherRelevantDataCountries": [
"US"
],
"status": "compliant"
},
"createUser": "datafier@osdu-service-prod.iam.gserviceaccount.com",
"id": "m19:master-data--Wellbore:9254"
}
],
"aggregations": null,
"phraseSuggestions": [],
"totalCount": 6668
}
```M22 - Release 0.25Dzmitry Malkevich (EPAM)Dzmitry Malkevich (EPAM)https://community.opengroup.org/osdu/platform/pre-shipping/-/issues/670IBM M22 - CRS Conversion - Coordinate Reference System not Loaded2024-01-27T06:33:10ZJuliana Fernandesjuliana.fernandes@iesbrazil.com.brIBM M22 - CRS Conversion - Coordinate Reference System not LoadedHello,
I was trying to complete the task FoR CRS Conversion for Manifest ingestion but I was not able to complete.
In one of the first steps were I need to check if the Coordinate Reference System is loaded into OSDU I got an empty ret...Hello,
I was trying to complete the task FoR CRS Conversion for Manifest ingestion but I was not able to complete.
In one of the first steps were I need to check if the Coordinate Reference System is loaded into OSDU I got an empty return.
- Collection used:https://community.opengroup.org/osdu/platform/pre-shipping/-/blob/main/R3-M22/QA_Artifacts_M22/envFilesAndCollections/Manifest_Based_Ingestion_Osdu_ingest_CI-CD_v2.0.postman_collection.json?ref_type=heads
- Environment used: https://community.opengroup.org/osdu/platform/pre-shipping/-/blob/main/R3-M22/IBM-M22/Environment/OSDU_R3_IBM_ODI_M22_ENV.postman_environment.json?ref_type=heads
### 02 - Search Coordinate Reference System (CRS) Record
**Body Curl Version**
```
curl --location 'https://cpd-osdu.apps.osdu-preship.ibmodi.com/osdu-search/api/search/v2/query' \
--header 'Content-Type: application/json' \
--header 'data-partition-id: opendes' \
--header 'Authorization: Bearer <Token>' \
--header 'Cookie: 5e7c4a992d2558462d1c9fcde6f1cee7=c87320314b80622dec9caac6b93398c9' \
--data '{
"kind": "osdu:wks:reference-data--CoordinateReferenceSystem:1.0.0",
"query" : "id:\"opendes:reference-data--CoordinateReferenceSystem:23031024\"",
"limit": 1000
}'
```
**Response**
```
{
"results": [],
"aggregations": [],
"phraseSuggestions": [],
"totalCount": 0
}
```
Is it the Coordinate Reference System not loaded or some wrong code?
Regards,
Juliana FernandesM22 - Release 0.25